Hi all

Just for fun, I inserted a 'knob control' into a spreadsheet. Now I can't select it or delete it. If I try removing the line or row the thing is in, it just reappears, and I get no options if I right click on it. I also get a 'do you want to run ActiveX?' message every time I start the workbook.

The particular worksheet this thing is in has lots of cross-references to other worksheets, so I don't want to have to copy the data (without knob) onto a new sheet.

How do I kill this thing?

Many thanks
Django Cat

--

I don't know what a knob control is, but maybe you have to be in design mode to
delete it.

Show the Control toolbox toolbar
(View|toolbars in xl2003)

Then click on that design mode icon
Rightclick on the control and click cut
and toggle out of design mode.



Django Cat wrote:

Hi all

Just for fun, I inserted a 'knob control' into a spreadsheet. Now I can't select it or delete it. If I try removing the line or row the thing is in, it just reappears, and I get no options if I right click on it. I also get a 'do you want to run ActiveX?' message every time I start the workbook.

The particular worksheet this thing is in has lots of cross-references to other worksheets, so I don't want to have to copy the data (without knob) onto a new sheet.

How do I kill this thing?

Many thanks
Django Cat

--

--

Dave Peterson

Dave Peterson said:

I don't know what a knob control is,

It's a small movable graphic of a rotary knob - you can imagine using it to control volume of a sound source.

but maybe you have to be in design mode to
delete it.

Show the Control toolbox toolbar
(View|toolbars in xl2003)

Then click on that design mode icon
Rightclick on the control and click cut
and toggle out of design mode.


Thanks Dave, that's done the trick.

I'd no idea Excel had a design mode, though I'm familiar with the idea from Access. What's the idea behind it?
DC
--

First, glad you got it off the worksheet.

Developers can add controls to worksheets--like you did with the rotary knob.

The controls that are on the control toolbox toolbar can be added by the
developer and modified to make them behave the way the developer wants them to
behave. But the developer has to be in developer mode (aka design mode). When
the developer is done, he/she turns that off and that makes the controls
available to the user.

Django Cat wrote:

Dave Peterson said:

I don't know what a knob control is,

It's a small movable graphic of a rotary knob - you can imagine using it to control volume of a sound source.

but maybe you have to be in design mode to
delete it.

Show the Control toolbox toolbar
(View|toolbars in xl2003)

Then click on that design mode icon
Rightclick on the control and click cut
and toggle out of design mode.


Thanks Dave, that's done the trick.

I'd no idea Excel had a design mode, though I'm familiar with the idea from Access. What's the idea behind it?
DC
--

--

Dave Peterson