What do you consider as a "worksheet"?

Worksheet or workbook passwords are not found under Security options. Encrypted
files and shared files passwords are found there.

Can you open the workbook/file without using a password?

This type of password is found under FileSave AsToolsGeneral OptionsPassword
to open or password to modify.

To remove a password from a worksheet, go to ToolsProtectionUnptotect sheet.

If I have misunderstood, post back or wait for someone else to take a crack at
this.



Gord Dibben MS Excel MVP


On Tue, 8 Aug 2006 12:00:02 -0700, wfleming
wrote:

I want to remove a password from a worksheet but am unable to do so because
the Password function is grayed out under the Security Tab on the Options
menu.