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
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