![]() |
Entire form is protected - Need help to understand
I developed a form with various fields to allow user to
input data. I protected the form except for those fields for users to enter data (using the "Allow users to edit ranges..." feature). It has been working for many users until now. I've 2 new users running Win 2000 and Win XP Prof on their respective laptops. When they open the form, the entire form is protected for unknown reasons. I checked their Excel Security and it was set to Medium. I then reset it to Low. Restarted the laptop and tried again but it did not help. Can someone please tell me why the entire form is protected ? What setting I'm missing to change ? Please help. |
Entire form is protected - Need help to understand
IF the users are using Excel 2000, then this could be the problem. Excel
2000 and earlier did not support cell protection based on users. -- Regards, Tom Ogilvy "Wellie" wrote in message ... I developed a form with various fields to allow user to input data. I protected the form except for those fields for users to enter data (using the "Allow users to edit ranges..." feature). It has been working for many users until now. I've 2 new users running Win 2000 and Win XP Prof on their respective laptops. When they open the form, the entire form is protected for unknown reasons. I checked their Excel Security and it was set to Medium. I then reset it to Low. Restarted the laptop and tried again but it did not help. Can someone please tell me why the entire form is protected ? What setting I'm missing to change ? Please help. |
All times are GMT +1. The time now is 05:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com