Hardware Man
New Member
- Joined
- Apr 10, 2013
- Messages
- 40
Hi Guys,
I have a workbook with a bunch of macros in it, several of which are called with activeX buttons on the worksheets themselves. I had a crash today and when I attempted to re-open the workbook, Excel had to "disable all ActiveX controls" in order to repair the file.
Now I'm getting a message box whenever I try to click on a worksheet button saying "Cannot run Macro XYZ, The macro may not be available in this workbook or all macros may have been disabled".
I went into the Trust Center and chose "Enable all macros" and "enable Active X Controls" but I'm still getting the same unhappy results. Any ideas?
I have a workbook with a bunch of macros in it, several of which are called with activeX buttons on the worksheets themselves. I had a crash today and when I attempted to re-open the workbook, Excel had to "disable all ActiveX controls" in order to repair the file.
Now I'm getting a message box whenever I try to click on a worksheet button saying "Cannot run Macro XYZ, The macro may not be available in this workbook or all macros may have been disabled".
I went into the Trust Center and chose "Enable all macros" and "enable Active X Controls" but I'm still getting the same unhappy results. Any ideas?