Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect worksheet - losing values
I did not want an excel file's users to insert new rows or columns (etc) and
hence i locked all those cells. I then went and protected the sheet 1. Enabled "Protect worksheet and contents of locked cells' checkbox 2. specified a password 3. checked only the items i wanted the Users to perform 4. So, i said "Allow all Users of this worksheet to:" 4.1 Select locked cells 4.2 Select unlocked cells 4.3 Format cells 4.4 Format rows 4.5 Sort 4.6 Use AutoFilter 4.7 Edit Objects I can now right click on any row and the "Insert' and "Delete" options are disabled - which is correct. The "Hide" and "Unhide" options are enabled - which is correct. Now, after some time or after the file is closed and opened, the "Hide" and "Unhide" options are disabled. Why are these settings being lost? It makes me mad, as i have sent this file to 10 users and the settings are retained for a while and go away after sometime.... Thanks for the help.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect worksheet - losing values | Excel Discussion (Misc queries) | |||
How do I merge cells without losing cell values? | Excel Worksheet Functions | |||
How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
transfer one worksheet to another worksheet without losing format. | Excel Worksheet Functions | |||
concatenating "00"&"00"&"01" without losing the zero values | Excel Worksheet Functions |