View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip[_3_] Chip[_3_] is offline
external usenet poster
 
Posts: 133
Default Protection problem...

I have protected worksheets on many occassions. However, I have some
dropdowns (done via forms) which even when I uncheck the "Locked" box
in the formatting window, and set the protection levels to allow pretty
much everything, still does not work. Any time I try to use the
dropdowns while it is protected it gives me the "This is protected..."
type of error message.

Any ideas on how to get around this....I just want to protect the
workbook but let the user use the dropdowns.