How to kill an ActiveX object
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 -- |
How to kill an ActiveX object
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 |
How to kill an ActiveX object
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 -- |
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 |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com