Transfer Macro to another user

P

Poolpa

Ive created a macro and I would like to send it to another user in order
for him to run it on his proper excel files. Ive sent him the file with
the macro attached, how can he register it to have it available each
time he'll open an Excel File?

Thanks

Poolpa
 
C

CLR

Hi Poolpa..........
If he wants the macro to be available to run on any Excel file that he might
open, then he can put it in his Personal.xls file, and put the Personal.xls
file in his xlStart directory.

hth
Vaya con Dios,
Chuck, CABGx3
 

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

Need Help with Macro Security 1
Building Blocks and Macros 5
Want to have macro execute automatically when doc created 3
Macro Pause to Select range then Subtotal 0
Macros to Rearrange Data?? 2
Macros to check whether all cells are filled 0
Synchronization problems while moving folders to new email 1
Getting information from one excel file into another? 1

Top