ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What is the easiest way to setup a 'global' macro which is always available to Excel on a PC? (https://www.excelbanter.com/excel-programming/283436-what-easiest-way-setup-global-macro-always-available-excel-pc.html)

Angus Comber[_2_]

What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?
 
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





Gord Dibben

What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?
 
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
ToolsAdd-ins. Leave it checked.

Gord Dibben XL2002

On Mon, 24 Nov 2003 13:07:40 -0000, "Angus Comber"
wrote:

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






All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com