Where is Personal Macro Workbook?

[fxcel]

Hello, I wanted to edit a macro, but Excel told me my personal macro
workbook was hidden and I needed to unhide it. Where the heck is it?
TIA

-F

 

[Dave Peterson]

If you created personal.xls, then you can have excel tell you where it was
saved.

Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window.
type this and hit enter:
?workbooks("Personal.xls").path
to get the drive/folder where it's stored.

?workbooks("Personal.xls").FullName
will include the name, too.

If you get some type of error message (and you did type stuff correctly), then
you didn't create that personal.xls workbook.

 

[Nick Hodge]

You don't need to find it if you just want to edit the macros. Click on
Tools>Macro>Macros...and select the macro in the list and press edit or
press Alt+F11 and select the modules below the personal.xls entry. (If there
isn't a personal.xls entry...you don't have one)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)