View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wellie wellie is offline
external usenet poster
 
Posts: 5
Default 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.