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

--

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!

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!

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!