View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default 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