Personal workbook

[afdmello]

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

VAA

 

[Debra Dalgleish]

It should be automatically created if you record a macro, and select to
store it in the Personal Macro Workbook.

There's some information here:


http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp#store

 

[Gord Dibben]

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

 

[afdmello]

Thank you I did it.

VAA