sending a macro to another person

J

Jack S

I have recorded a macro to move data around inside an excel spreadsheet
[Office 2007]. It is stored on my personal workbook and available to all open
workbooks.
Others in the company have spreadsheets in the exact same format and could
use this macro. How do I send the macro to them? When they receive it what do
they have to do to use it in any of their worksheets?
 
G

Gord Dibben

Are you on a network?

Best might be to simply save as your Personal.xls as an add-in named
something else like TheMacros.xlam

Store that in a central location that all users can access.

They then load the add-in to have the macros available.


Gord Dibben MS Excel MVP
 

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
How to save/move a personal workbook 4
Word macro that can call cells out of Excel for a find and replace 0
Personal Macro 1
Locking by multiple users possible? 0
Excel 2007: Creating a macro that will run Solver. 0
saving macro from workbook to Personal Macro Workbook 1
Excel 2007: Help creating a macro that will run Solver? 3

Top