Unable to use controls when sheet is protected
 

If you use linkedcells, make sure that they're not locked when you protect the
sheet.

Kirk wrote:

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

--

Dave Peterson