'Cannot insert object' message when I try to put a button on a worksheet

  • Thread starter Thread starter musicalhacksaw
  • Start date Start date
M

musicalhacksaw

Dear Excel/ VBA programmers,
Every time I try to insert a command button from the 'Insert>Active x>Command Button menu to an Excel Worksheet, I get a 'Cannot insert object' response. I was able to use Active X menu selections previously, but it seems my Excel won't let me do so anymore.

I need to have use of the Active X tools as I want to test a Visual Basic program - and not a macro, which I understand are the control form (upper) tools.

I did find a suggestion on the net which was to delete all temp files on mycomputer, but this did not make any difference, I still get that message.

I hope you can help out. Thank you for reading.
Yours
Simon Evans.
 
Hi,

Am Thu, 11 Dec 2014 09:47:49 -0800 (PST) schrieb
(e-mail address removed):
Every time I try to insert a command button from the 'Insert>Active x>Command Button menu to an Excel Worksheet, I get a 'Cannot insert object' response. I was able to use Active X menu selections previously, but it seems my Excel won't let me do so anymore.

I need to have use of the Active X tools as I want to test a Visual Basic program - and not a macro, which I understand are the control form (upper) tools.

I did find a suggestion on the net which was to delete all temp files on my computer, but this did not make any difference, I still get that message.
Click to expand...

that is since the last patch day
For xl2007 delete patch KB259627
For 2010 and 2013 delete patch 2553154


Regards
Claus B.
 
Dear Claus, thank you for your advice.
I have read up on the net of Microsoft's issuing of patches causing problems for users of their software, but the articles say nothing on how to remove these patches.

Could you tell me how to remove these patches - if you know.
Thank you
Simon.
 
Dear Excel/ VBA programmers,
Every time I try to insert a command button from the 'Insert>Active
x>Command Button menu to an Excel Worksheet, I get a 'Cannot insert
object' response. I was able to use Active X menu selections
previously, but it seems my Excel won't let me do so anymore.

I need to have use of the Active X tools as I want to test a Visual
Basic program - and not a macro, which I understand are the control
form (upper) tools.

I did find a suggestion on the net which was to delete all temp files
on my computer, but this did not make any difference, I still get
that message.

I hope you can help out. Thank you for reading.
Yours
Simon Evans.
Click to expand...

You can use either of the controls to access code in your 'program'
since the code in VBA projects *are* macros!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Hi Garry,
Do you mean I ought use the upper selection of tools, the control form ones, rather than the lower ones, the Active X ones (as offered by 'insert' menu) ?
Isn't this a bit like caving in to the powers that be ? (Microsoft, that is to say)
If I got another edition of Excel - would I still have the same problem ?
I have got Excel on my Laptop, which wasn't connected to the net the last couple of months - maybe I should use that, but I'd prefer working on my PC.
Yours
Simon
 
Hi Garry,
Do you mean I ought use the upper selection of tools, the control
form ones, rather than the lower ones, the Active X ones (as offered
by 'insert' menu) ? Isn't this a bit like caving in to the powers
that be ? (Microsoft, that is to say) If I got another edition of
Excel - would I still have the same problem ? I have got Excel on my
Laptop, which wasn't connected to the net the last couple of months -
maybe I should use that, but I'd prefer working on my PC. Yours
Simon
Click to expand...

I have several versions of Excel installed, from v8 to 2010. All
versions require drawing the rectangle for the control object on the
worksheet. Both types (Form/ActiveX) come from Micro$oft and so doesn't
qualify either for not 'caving in' to the powers that be.

FWIW:
Personally, I don't like using controls on a worksheet and so I tend to
have my 'programs' create their own menus, leaving the worksheets clear
for data only. If I do need an 'action execution' fired from a
worksheet cell then I make that cell look/feel like a button and use
Worksheet_SelectionChange events to redirect to the macro assigned to
that cell address.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Hi,

Am Thu, 11 Dec 2014 14:31:39 -0800 (PST) schrieb
(e-mail address removed):
I have read up on the net of Microsoft's issuing of patches causing problems for users of their software, but the articles say nothing on how to remove these patches.
Click to expand...

I don't know how the elements are named in your language version.
System control => Programs => Installes Updates
Search for the patch and deinstall

Regards
Claus B.
 
Hi Claus,
I uninstalled about half the updates since the date of when the 'Active X' controls last stopped working - and it is working again.
Thanks
Simon
 
Back
Top