protection removal

[meduk]

When entering
tools....protection
there is no "unprotect"
How do I remove protection from workbook and worksheets.
Using Vista and excel 2003

 

[Mike H]

Hi,

That could be because there is no protection on the sheet/book. have a look
here for help on menu options

http://www.mvps.org/dmcritchie/excel/grayedout.htm

Mike

 

[Gord Dibben]

I would suggest if there is no "unprotect sheet" or "unprotect workbook"
available then you have no protection to remove or the workbook is shared.

If you have more than one sheet selected there will be no protect or unprotect
sheet available.

What is available on Tools>Protection?


Gord Dibben MS Excel MVP

 

[meduk]

Thank you for help
The sheets were protected
I have now sorted problem using micosoft assistant.
Open worksheet
on tools select other options
delete asterisks (password)
ok
save
yes to replace
Problem solved