Personal workbook

  • Thread starter Thread starter afdmello
  • Start date Start date
A

afdmello

I have read about the personal macro workbook . I cant find it in the
XLStart folder . How do I create it.

VAA
 
VAA

One method....

On menu go to Tools>Macro>Record New Macro.

You will be presented with a dialog box with Macro1 as name of macro. Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to Personal.xls

Click Yes. You now have a Personal.xls which will open each time you start
Excel. When it is open, you can go to Windows>Hide and make it hidden. Save
changes again.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top