I had seen that Personal.xls but was unsure how to use it. I'm familiar with
recording macros but not that knowledgable. Looking to learn more about
Visual Basic and programming them so I can be even more fierce (or dangerous)!
Thanks a ton.

"Gord Dibben" wrote:

Missy

That's what Personal Macro Workbook is all about.

Store your macros in Personal.xls, place it in your XLSTART folder and it will
open when Excel is started.

Personal.xls is created the first time you record a Macro using Macro
Recorder.

ToolsMacroRecord New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording, typing or copying into the Module.

You can do a FileSave from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit WindowHide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

I prefer to place my global macros in an add-in so I don't have to preface
macros with the Personal.xls filename.


Gord Dibben Excel MVP

On Fri, 9 Dec 2005 12:00:04 -0800, MissyLovesExcel
wrote:

Would it be wise to store all macros in one workbook in order to open the one
source and access your macros from "All Open Workbooks" so to not have to
remember which file you used/saved it in previously?