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

Unable to use controls when sheet is protected
 

Not sure what bearing that has on using the controls.

--
Regards,
Tom Ogilvy

"Kirk" wrote in message
...
Current Protect Sheet Settings allow the user to "Select locked cells" and
"Select Unlocked cells". Which all of the controls are Locked.

Kirk

"Tom Ogilvy" wrote:

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