where can i store macros?

[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

 

[Don Guillett]

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.

 

[Amy Heavy]

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

 

[Gord Dibben]

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