View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel 2007 - Macro Not Available

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Angie" wrote in message ...
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!