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