How/where do I save VBA macros to be used in future sreadsheets

[fiesty]

I have 5 macros that I use in one spreadsheet which works great but how/where can I save them to use in other worksheets? I keep losing the macros I create and have to redo them.

I really appreciate all the help I received from forum members since I am new to Macros I guess my next post will be on how to join the 5 macros into 1.

[xlbiznes]

Hi,

have a look at this link.

http://fontstuff.com/vba/vbatut03.htm

[fiesty]

Thanks! I will check it out.

[fiesty]

I must have done something wrong. Now I cannot see the left side where it lists the modules and sheets. How do I get this back?

[fiesty]

never mind about the screen problem - I got it back go normal. Brain Overload with macros

[alansidman]

fiesty;
Also look at this link that show how to set up a macro spreadsheet for those vba issues that are not UDFs.

http://www.rondebruin.nl/personal.htm

[fiesty]

This document is easier for me to undertand - Brain overload now so I will work on it tomorrow evening.

[xladept]

Hi Feisty,

It sounds like you want an Add-in.

[fiesty]

Thanks everyone for your help - I think I got it to work