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
(e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easiest way to add functionality to ALL Excel spreadsheets 5
Global Template Network and saving auto texts & macros 2
Use macro code from external xls file 1
Com add-ins and Macro security 1
Global Macro 1
Custom XLAM tab not showing up when excel is opened from word 0
Make global Macro/Add-in for all active Workbooks/Sheets 6
Access doesn't always close (Excel VBA) & passing parameters 9

Top