Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect/Unprotect Worksheet
I have a workbook that is shared by many. The settings for protection are
different for each worksheet. I am suddenly unable to edit my worksheet because it is protected and all the options with the exception of "unprotect workbook" are disabled. Even when I unprotect the workbook, I still can't do anything. Can anyone help me please? Thanks. |
#2
|
|||
|
|||
Do you see [Shared] after the workbook name on the title bar.
If so then Tools, Share Workbook ..., uncheck Allow changes by more than one user at the same time. If you turned on highlight change you would get a shared workbook --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "djn" wrote in message ... I have a workbook that is shared by many. The settings for protection are different for each worksheet. I am suddenly unable to edit my worksheet because it is protected and all the options with the exception of "unprotect workbook" are disabled. Even when I unprotect the workbook, I still can't do anything. Can anyone help me please? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |