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 |
All times are GMT +1. The time now is 02:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com