Starting a macro from a custom button 1

[Mikeb1970]

Hi all,

I'm sure this is quite simple, just haven't read anything about this sofar.

I've created a costum toolbar containing two buttons,and i did asign a macro to both of them, when i save my work i get a request if i want to save the changes.

What do i need to change when the next time i open excel the code is assigned to the buttons, like an addin?

Thnx for any help posted

With regards

Need to use Office 2000 at work :-(

 

[waynerenaud]

If I have understood your question correctly, you need to save them in personal.xls. If you dont have personal.xls go to tools/macro/record new macro in the window that pops up choose personal macro workbook from the dropdown. You can then copy your modules/macros into personal.xls which can be found in C:\Documents and Settings\yourusername\Application Data\Microsoft\Excel\XLSTART this may vary dependant on operating system and version of excel.
Or open VBE and personal.xls will show up in the project explorer window.
Hope this helps