View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.