Where is Personal Macro Workbook?
 

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


--
fxcel
------------------------------------------------------------------------
fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864
View this thread: http://www.excelforum.com/showthread...hreadid=552909

Where is Personal Macro Workbook?
 

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.

fxcel wrote:

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

--
fxcel
------------------------------------------------------------------------
fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864
View this thread: http://www.excelforum.com/showthread...hreadid=552909

--

Dave Peterson

Where is Personal Macro Workbook?
 

You don't need to find it if you just want to edit the macros. Click on
ToolsMacroMacros...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
HIS


"fxcel" wrote in
message ...

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


--
fxcel
------------------------------------------------------------------------
fxcel's Profile:
http://www.excelforum.com/member.php...o&userid=24864
View this thread: http://www.excelforum.com/showthread...hreadid=552909