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
"Per Jessen" wrote:
> 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
>
> On 12 Sep., 22:12, MjMullen <MjMul...@discussions.microsoft.com>
> wrote:
> > 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"?
>
>
|
Similar Threads
