Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protection...
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 |
#2
|
|||
|
|||
Try this, Danielle:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "danielle" wrote in message ... 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 |
#3
|
|||
|
|||
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. "Anne Troy" wrote: Try this, Danielle: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "danielle" wrote in message ... 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 |
#4
|
|||
|
|||
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. danielle wrote: 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. "Anne Troy" wrote: Try this, Danielle: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "danielle" wrote in message ... 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Three levels of protection in one worksheet | Excel Worksheet Functions | |||
Cell protection in Excel is lost when file is uploaded to website. | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
protection on excel forms | Excel Worksheet Functions | |||
How may I remove Office 2003 DRM protection from DOC & XLS files? | Excel Discussion (Misc queries) |