Excel 2007 - Macro Not Available

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!
 
R

Ron de Bruin

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
 
A

Angie

I see VBAProject (PERSONAL.XLSB) and VBAProject (PERSONAL.xlsm), but the
macros I saved on the quick access toolbar aren't listed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top