Skip to Content
Former Member
Dec 21, 2011 at 12:34 PM

Buttons not working when workbook is opened. Error says about macro.


Hi Gurus,

I have created a workbook and it was working fine. But now when i open the workbook it throws an error saying " Cannot run the macro Workbookname.button_click. The macro may not be available in this workbook or all macros may be disabled" . What I find surprising is that it was working fine and it suddenly changed like this.

It can be solved if I toggle between the design and analysis mode in Analyzer. Isn't there any other solution for this. I was wondering how my workbook suddenly changed its behavior. I would really appreciate if anyone could tell me a solution for this issue.

Thanks in advance,

Jerry Jerome