protection removal

M

meduk

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

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
 
M

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
 
Top