View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to kill an ActiveX object

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