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
|