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,