Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bug - Protect Sheet ?
Hi I am using Excel 2002 SP3
I want to Protect a sheet to prevent users from making certain changes (delete rows, some cells etc). When I use the Tools Protect Sheet option I select "Format Columns", Edit Obects, Edit Scenarios and Use Autofilter. Basically I allow them to resize columns, use hyperlinks and the autofilter. It seems to work fine once I do this. Once I save the sheet and close it and then reopen it the user seems to have no ability to resize columns or any of the other things. Is this a bug or have I done something wrong? When I unprotect the sheet and immediatley protect it again the options I previously selected are not selected anymore thanks -- Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect more than one sheet at a time | Excel Discussion (Misc queries) | |||
How to protect all sheet ? | Excel Worksheet Functions | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
help with protect sheet | Excel Discussion (Misc queries) |