Excel Macro Command Button Not Working

[jaterjr]

I have a Excel macro that doesnt work when trying to click the button. This only happens on one computer all other computers can run the macro successfully. I dont know what the problem is. The macro settings are enabled as well. If anyone can help it would be greatly appreciated. Thanks!

 

[RoryA]

Try this: http://support.microsoft.com/kb/3025036/EN-US

 

[three_toe]

What versions of Excel are you running? Is the problem computer running a different version? Does the problem computer have other administrators that restrict your permissions and access?

If everything is identical, have you tried going into VB editor and running it from there? If so, what happens?

 

[jaterjr]

Yes, I was wondering if this was the issue. I seen that, after it updated, it installed "Office 2010 Macro Bypass..."

 

[jaterjr]

I'm running 2007. Everything is the same except the update on that computer made last week. I went to VB editor and it wouldnt play.

 

[vds1]

Do you get any error while inserting a command button ?

To Insert command button you goto Developer | Insert | Command button under activex control

 

[jaterjr]

I did it. It does come back with an error. "Cannot insert object"

So it is the update then.

 

[jaterjr]

Thanks guys. We got it working. I had to do the Fix It in that website then enable macros in the setting.