Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
protect more than one sheet at a time jbJB Excel Discussion (Misc queries) 2 November 15th 06 07:42 PM
How to protect all sheet ? vumian Excel Worksheet Functions 6 August 4th 06 06:02 PM
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Can I protect columns w/in a "List" using Protect Sheet? Diane Excel Discussion (Misc queries) 0 May 10th 06 03:30 PM
help with protect sheet WYN Excel Discussion (Misc queries) 14 February 18th 05 10:26 PM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"