View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Unable to use controls when sheet is protected

Take the sheet out of design mode.

When you protect the sheet, don't select objects as one of the things to
protect.

--
Regards,
Tom Ogilvy


"Kirk" wrote in message
...
I have a spreadsheet that uses Combo Boxes and Command controls. When the
spreadsheet is protected, the user is unable to do anything with the

controls.

I unprotected the sheet, and the controls go into Design Mode. I can't

seem
to figure out why the controls won't work.

Any ideas as to why this is?

Any help would be appreciated. Thanks.

Kirk