Design Selecting Controls

[MjMullen]

I have an inherited an Excel 2000 application with a "menu" spreadsheet that
has several controls.

I have entered the VBA module (Alt-F11) and activated the toolbar, placed
the sheet into design mode via the command bar button, but the sheet isn't
entering into design mode.

I am unable to select any of the controls (list boxes, buttons) to either
re-position them on the sheet or modify their properties.These are not
selectable by right click technique either.

The sheet is not protected, and although I can place new controls on the
sheet, I'd rather modify the properties of the controls.

Any thoughts on how to make the sheet "editable"?

 

[Per Jessen]

Hi

As the controls are in a sheet, you have to turn the sheet into design
mode.

With the desired sheet open, right click on the menu bar and select
"Control Toolbox", click "Design Mode" on this tool bar. Now you
should be able to manipulate the controls.

Regards,
Per

 

[MjMullen]

Ah, but that's the rub - the design button has no effect on this sheet. I'm
at a loss as to why this sheet does not respond to the button. Even after
clicking on the button (in both the excel sheet and by trying from the VBA
editor and going to the page module and selecting "form" above) the page
doesn't respond. A combo box will merely dhow it's drop down list, not be
'selected' so I can get to the properties and change the list reference, in
this case.

As I said, first time I've run into this on Excel 2000 ...
Mike