in excel i want to make a sheet unprotected from the protection
 

here is the problem that i want to make worksheet unprotected but the option
in "tools" menu in "protection" sub menu is not highlighted plz help me

in excel i want to make a sheet unprotected from the protection
 

If the workbook is also "Shared" you cannot unprotect it.

Unshare first then unprotect.

ToolsShare Workbook

OR you may have more than one sheet selected.

Do you see [Group] next to the filename in Title Bar?


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 21:59:05 -0800, imran
wrote:

here is the problem that i want to make worksheet unprotected but the option
in "tools" menu in "protection" sub menu is not highlighted plz help me