View Single Post
  #4   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

This is the correct file
PERSONAL.XLSB

Do you create this file yourself ?
PERSONAL.xlsm

Maybe remove the files from XLstart and create a new PERSONAL file
http://www.rondebruin.nl/personal.htm

--

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


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

"Ron de Bruin" wrote:

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!