Protection...

D

danielle

How do I unprotect a worksheet or workbook? I'm trying to unmerge cells and
it won't let me do it. I think it might have something to do with me
protecting it.

Thanks
 
D

danielle

Thanks for the response but it still didn't work. When I go to
Tools/Protection, both the Protect Sheet and Protect Workbook selections are
grayed out and those are the ones i need.
 
D

Dave Peterson

Are multiple worksheets grouped
(to make the tools|protect|unprotect sheet greyed out)?
If yes, then select only one sheet. (rightclick on any of the selected tabs and
choose "ungroup sheets".)

Is the workbook shared?
If yes, unshare it.
Tools|share workbook|editing tab|uncheck the "allow changes by more than..."

====
If you look at the title bar, you'll see [Group] or [Shared] at the end of the
workbook name.
 
Top