ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Entire form is protected - Need help to understand (https://www.excelbanter.com/excel-programming/299973-entire-form-protected-need-help-understand.html)

wellie

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.

Tom Ogilvy

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