Passwording

[celake]

Is it possible to password a worksheet with in a document so that it can not
be viewed by anyone without that password. I know I can set it so that it can
not be changed without the password.

 

[Frank Kabel]

Hi
in the saveas dialog you can set a Read password

 

[celake]

Doesnt' that do the whole workbook though? I am curious for just a worksheet
within the workbook.

 

[Frank Kabel]

Hi
for just a worksheet you'll have to create a macro but this kind of
protection can easily be circumnvented

 

[anilsolipuram]

to password protect worksheet.

go to tools->protection->protect sheet-> selec
contents,objects,scenerio , enter password and reenter password when i
prompts for re-confirm password, click ok.

now your worksheet is password protected

 

[Gord Dibben]

You can hide the worksheet then Tools>Protection>Protect Workbook.

Users can open and edit the visible sheets, but need the password to get at
the hidden sheet.

Gord Dibben Excel MVP

 

[celake]

Thanks

You can hide the worksheet then Tools>Protection>Protect Workbook.

Users can open and edit the visible sheets, but need the password to get at
the hidden sheet.

Gord Dibben Excel MVP