Copying a macro to another spreadsheet

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

I have a macro (assigned to a button) within my excel spreadsheet. I want
to give this macro (and button) to several my colleagues for them to insert
into their spreadsheet. What is the easiest way of doing this?

I right clicked on my button and selected Copy. I then loaded up one of the
spreadsheets and pasted it in. Looked good. Button and Macro worked in her
sheet. However, one of the "side effects" was that when she clicked the
button it opened my spreadsheet on her computer. (we are on a network and
our spreasdsheets are in the same directory). Obvioulsly the button I
copied and pasted is linked to my spreadsheet. I'd like to divorce that to
ensure my colleagues spreadsheets are "stand alone".

Thanks
 
Hi Gerry,

Jan Karel Pieterse wrote this article:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a macro (assigned to a button) within my excel spreadsheet. I want
| to give this macro (and button) to several my colleagues for them to insert
| into their spreadsheet. What is the easiest way of doing this?
|
| I right clicked on my button and selected Copy. I then loaded up one of the
| spreadsheets and pasted it in. Looked good. Button and Macro worked in her
| sheet. However, one of the "side effects" was that when she clicked the
| button it opened my spreadsheet on her computer. (we are on a network and
| our spreasdsheets are in the same directory). Obvioulsly the button I
| copied and pasted is linked to my spreadsheet. I'd like to divorce that to
| ensure my colleagues spreadsheets are "stand alone".
|
| Thanks
|
|
 
Back
Top