Solved: Custom toolbar for use in all instances of Excel

[OTWarrior]

I like to create my own toolbars in Word to use my own custom made functions (saving them to the Normal.dot in Word) and would like to do the same in Excel. However, I noticed there is no Normal.dot option when saving the macros.

Is it held elsewhere? If so, how would I go about achieving this feature?

I have already created a custom toolbar and functions, but it loads teh original workbook every time I use one of the macros (providing the workbook isn't loaded already).

Anyone else have this problem?

[Jan Karel Pieterse]

Excel's equivalent is called Personal.xls.
Record a macro and tell excel to put it in "your" personal macro workbook to have Excel automagically create a personal.xls for you.
Then quit excel and "yes" to the prompt to save changes to your personal macro workbook.

[Aussiebear]

... automagically ......

Now there's the word for the day!

[OTWarrior]

Awesome, thank you very much