K
K
Hi, I have macro setup on a button in one of my worksheet. Lots of
other people also have
to use that worksheet for their work purpose. But to use that
worksheet they need to
copy that worksheet into their workbooks or Excel Files and the best
way to copy that
worksheet (with which they can get all the formulas and other formats)
is to right click
on that worksheet tab and click "Move or Copy" comand to transfer it
to their workbooks.
The problem is that when they get copy of my worksheet in their
workbooks or files and
when they click that button in which the macro is setup to work then
by clicking that
button it openes up the original worksheet aswell. I want someway
that when they copy
my worksheet into their workbooks then they should also get the macro
to be copied
aswell. I know the copy method I mentioned above will copy the
worksheet macro
but how to copy the Module macro. Please if anybody can help in
this. Thanks
other people also have
to use that worksheet for their work purpose. But to use that
worksheet they need to
copy that worksheet into their workbooks or Excel Files and the best
way to copy that
worksheet (with which they can get all the formulas and other formats)
is to right click
on that worksheet tab and click "Move or Copy" comand to transfer it
to their workbooks.
The problem is that when they get copy of my worksheet in their
workbooks or files and
when they click that button in which the macro is setup to work then
by clicking that
button it openes up the original worksheet aswell. I want someway
that when they copy
my worksheet into their workbooks then they should also get the macro
to be copied
aswell. I know the copy method I mentioned above will copy the
worksheet macro
but how to copy the Module macro. Please if anybody can help in
this. Thanks