Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 8th 07, 08:55 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 12
Default 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

--


  #2   Report Post  
Old November 8th 07, 11:45 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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
  #3   Report Post  
Old November 8th 07, 07:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 12
Default 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
--

  #4   Report Post  
Old November 8th 07, 07:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
how do I kill the clipboard PERMANENTLY? Dave F Excel Discussion (Misc queries) 1 October 12th 06 06:23 PM
Kill Macro Jeff Excel Discussion (Misc queries) 4 September 27th 06 04:33 PM
On time kill Antonio Excel Discussion (Misc queries) 4 June 8th 06 10:50 AM
How to Kill Copy-Paste my911 Excel Discussion (Misc queries) 5 August 29th 05 12:20 AM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017