Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing workbook removes cell protection
This happened twice on the same workbook: I protected cells (allowing
user to select but not modify cells or change data), then protected the sheets with a password, then shared the workbook with track changes set up. If I then select a cell that's supposed to be protected, I can delete the data. If I unprotect a sheet in order to view the cell formatting, all the cells I protected are now unprotected. Anybody know what the heck is going on? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing workbook removes cell protection
I had this happen to me:
The cells in the worksheet were unlocked somewhere in the process of creating it and thinkig the cells were already locked, I did not check to confirm when protecting the worksheet. Goshute |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protection Sharing | Setting up and Configuration of Excel | |||
Error: Sharing Workbook w/password protection | Excel Discussion (Misc queries) | |||
File protection / Sharing / Conflicts | Excel Discussion (Misc queries) | |||
How do I remove protection and sharing from an Excel workbook? | Excel Discussion (Misc queries) | |||
protection, formulas and sharing with dummies | Excel Discussion (Misc queries) |