Macro

[Eric]

Hello,

How can I have a macro always available in Excel (97) for my users, but that
does not get copied automatically to every new workbook?

Thank you.

Eric.

 

[Ron de Bruin]

Hi Eric

You can copy your macro in a new workbook and save that
workbook as a Add-in and give that to your Users.

http://support.microsoft.com/default.aspx?scid=kb;en-us;156942&Product=xlw
XL97: How to Create an Add-in File in Microsoft Excel 97

 

[Eric]

Works great !

Thank you.

Eric.

Hi Eric

You can copy your macro in a new workbook and save that
workbook as a Add-in and give that to your Users.

http://support.microsoft.com/default.aspx?scid=kb;en-us;156942&Product=xlw
XL97: How to Create an Add-in File in Microsoft Excel 97