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
|