Macro

Eric · Jan 14, 2004

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 · Jan 14, 2004

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 · Jan 14, 2004

Works great !

Thank you.

Eric.

Ron de Bruin said:
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