Excel VBA not running

[fuzzbug]

I have a workbook with two buttons and some double-click event code that used to work.

Now clicking on the buttons does nothing and the double-click code has also stopped working.

There are no error messages. It is as if the VBA was not there.

I don't think there is a problem with the VBA as this has not changed since it worked. I don't want to go back to the version from a month ago (in which the same VBA works) because I have done a LOT of work on the workbook since then.

Is there a switch somewhere which turns VBA on/off? (NB macros are enabled)

[CADman69]

I'm not sure what version of excel your working with. If you open up your macro's dialog box, in 2007 under the developer tab there is a macro button in the ribbon. If you select the macro from there and press run does it work.. If so then it seems that the buttons you created lost focus and may need to be mapped to that macro again. Also make sure that the security level is set properly. If set on high, you won't be able to run any macro. I have mine set on medium, which prompts me to enable them everytime I start up that spreadsheet.

Give this a try, let me know how it goes.

[CADman69]

Just reviewing my post for accuracy and noticed your sub title of Office 2010. Please ignore my first sentence asking what your running. 2010 should be pretty similar to 2007, so I hope I can help. i would also recommend checking the active X settings. You will find that in the trust center (select macro security also under development tab.)