View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default Personal Macro Workbook

The personal.xls file is usually hidden from view. It is also usually and
should be resident in the XLStartup folder usually under your Program
Directory of MSO- Excel.
If you have Excel open currently Click on the Menu, WIndow, Unhide.. if you
see Personal then click on it to unhide it. Once it is open (and you are
viewing the Spreadsheet - Do Alt-F11 which should take you to the VBE.
Good luck..
Jim May

Do a search for the file Personal.xls -- Once youAs long as you save

"Frustrated" wrote:

I created new macros for a worksheet and ran them. Later I came back so I
could edit them by copying part of one and placing it in another one. I
could not find my Personal Macro Workbook. It would not give me the option
to open it when I came to the window the displays the Macro names. How do I
find this workbook and the macros that I created?