Excel 2007 - Macro Not Available

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

In Excel 2007, I created 2 macros, saved them to personal.xlsb, and even
added them to my quick access toolbar. But the next day I opened Excel and
tried to run the macro and got this error: "Cannot run the macro
'PERSONAL.XLSB!eTime1'. The macro may not be available in this workbook or
all macros may be disabled."

I verified my Macro Settings, which are set to "Enable all macros." When I
go to WINDOW, the UNHIDE button is gray (unavailable), so obviously my
personal workbook is not hidden.

So why am I getting this error? Any help would be appreciated. Thanks!
 
Hi Angie

If you use Alt F11 to open the VBA editor do
you see the 'PERSONAL file in the project explorer to the left
 
I see VBAProject (PERSONAL.XLSB) and VBAProject (PERSONAL.xlsm), but the
macros I saved on the quick access toolbar aren't listed.
 
Back
Top