What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?

A

Angus Comber

Hello

I understand that I can create an Add-in. In Word you can simply store a
document with a macro in the startup folder. Is this method possible in
Excel?

Angus Comber
[email protected]
 
G

Gord Dibben

Angus

You can store the *.XLA in your XLSTART folder to have it open when Excel
does.

OR you can store it in the Office\Library folder and access it through
Tools>Add-ins. Leave it checked.

Gord Dibben XL2002
 
Top