Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotecting worksheets
I recently created a workbook that I shared with other users in our network.
I protected and locked certain cells, only allowing some to be changed without a password. Now, I am trying to edit the cells and it doesn't even prompt me for my password, I can't do anything! When I go to "unprotect sheet" like Excel help says, only "Protect sheet" is an option (other is greyed out). Also I cannot even right click on any of the locked cells to "unlock them". I don't know what to do!!!!!! I spent hours working on these worksheets! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotecting worksheets
Lauren,
You will have to un-share the workbook, make the changesa and then re-share. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Lauren" wrote: I recently created a workbook that I shared with other users in our network. I protected and locked certain cells, only allowing some to be changed without a password. Now, I am trying to edit the cells and it doesn't even prompt me for my password, I can't do anything! When I go to "unprotect sheet" like Excel help says, only "Protect sheet" is an option (other is greyed out). Also I cannot even right click on any of the locked cells to "unlock them". I don't know what to do!!!!!! I spent hours working on these worksheets! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotecting worksheets
Remove the file from sharing first & then try. Certain commands are not
available when the file is shared. "Lauren" wrote: I recently created a workbook that I shared with other users in our network. I protected and locked certain cells, only allowing some to be changed without a password. Now, I am trying to edit the cells and it doesn't even prompt me for my password, I can't do anything! When I go to "unprotect sheet" like Excel help says, only "Protect sheet" is an option (other is greyed out). Also I cannot even right click on any of the locked cells to "unlock them". I don't know what to do!!!!!! I spent hours working on these worksheets! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting and Unprotecting several worksheets at one time | Excel Discussion (Misc queries) | |||
Unprotecting Sheets | New Users to Excel | |||
Macro for protecting and unprotecting multiple worksheets | Excel Discussion (Misc queries) | |||
Unprotecting Worksheets | Excel Discussion (Misc queries) | |||
Unprotecting worksheets | Excel Worksheet Functions |