View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MjMullen MjMullen is offline
external usenet poster
 
Posts: 4
Default Design Selecting Controls

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"?