Working With Worksheets

After you protect a worksheet, a user must use the appropriate password to make modifications to it. A user specifies the password in Excel by clicking Tools O Protection O Unprotect Sheet and typing the appropriate password for the sheet in the dialog box that appears. When the user types the appropriate password, the worksheet remains unprotected and the user can make any necessary modifications.

You can unprotect the worksheet from within a procedure with the Unprotect method. You use this method with any sheet or workbook that you want to protect. If you use this method with an unprotected worksheet, Excel ignores it and the worksheet remains unaffected.

The only parameter required for the Unprotect method is the Password parameter. You must use this parameter as a string to represent the password of the worksheet you want to unprotect. Remember that the password is case-sensitive and must match the current password of the worksheet. For example, ActiveWorkbook.Unprotect Password:="Excel" unprotects the active worksheet by passing it the correct password.

Remember to keep track of the passwords that you have assigned to worksheets. If you lose a password, you cannot access the password-protected document.

0 Specify any other parameters you need to protect the worksheet.

B] File

< Type Password:="Excel", replacing "Excel" with the password you want to use to unprotect the worksheet.

Type

AllowFormattingCells:=True.

Jit View Insert Format is aßy X

fr 415

lools Data Window Hel[

Type a question for help • . ff x - 10 - B I U = = = »

B] File

Jit View Insert Format is aßy X

fr 415

lools Data Window Hel[

Type a question for help • . ff x - 10 - B I U = = = »

A I B C I D I E F G

H

I

J

K

L

-

1 2

Monthly Expenses

Rent Groceries Fuel

Electricity Child Can Misc.

March

April

$750.00 750 750 750 $750.00

Î214.00 311

$75.00

$87.00

$110.00 $175.00

$1,411.00

88

89

110

145

1493

245

90

99

110

123

1417

25S

79

103

110

211

1509

Î307.00

$100.00

$110.00

$110.00

$345.00

$1722.00

June

75C

350 85

120 110 149

10

750

q-in Qâ

UK un iqn

August

750

~Y2 13

Septemb October

750 750

. The cell or chart you are trying to change is protected and therefore read-only,

Novembe

75C

15

Decembe

750

lection submenu). Vou mc

y be prompted for a password.

18

I—^—1

19

20

21

24

2b 26

-

H -< ► H \sheetl / sheets / SheeM

Sheet2 /S

< M

Ready

0 Specify any other parameters you need to protect the worksheet.

-■ Excel no longer allows modifications to the worksheet.

0 0

Post a comment