where can i store macros?

  • Thread starter Thread starter Amy Heavey
  • Start date Start date
A

Amy Heavey

In versions of excel pre 2000, there was a normal.xls that was the
default worksheet that opened when you created a new workbook.
Macros that you wanted in every worksheet you added to this
workbook.

Is there any way to do this in v 2000?

Thanks
 
In excel 95 macros were in the workbook.

In excel 97 + there is personal.xls. Normal is word.
If you don't already have personal.xls then just record any old macro to it
(select where to record) and it will be created for you.
 
Thanks

I'll give those a go, by the way, you mention MacXL, does this use VBA
aswell, I thought it was windows only?

Amy
 
Amy

If you are thinking of a Personal Macro Workbook which contains macros
available to all workbooks, it is/was named PERSONAL.XLS.....not Normal.xls

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. The macros you create will be available to work in all
workbooks.

If this is not what you need, post back and we'll try again.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top