Macros available to several workbooks
 

I have 3 seperate reports that all act similarly (tracks the same data for
different departments). I'd like to record one set of macros assigned to one
userform but available in all 3 reports. What's the easiest way to do with
without saving the userform and macros in each file? I don't want 3
userforms popping up if they open all three files.

Macros available to several workbooks
 

Put you code and userform in an Addin and then create a reference from each
workbook to the addin. This will insure the Addin is loaded when any of the
workbooks are open. Then you would need to add code in the addin to have
the userform behave as you desire.

--
Regards,
Tom Ogilvy


"StephanieH" wrote in message
...
I have 3 seperate reports that all act similarly (tracks the same data for
different departments). I'd like to record one set of macros assigned to
one
userform but available in all 3 reports. What's the easiest way to do
with
without saving the userform and macros in each file? I don't want 3
userforms popping up if they open all three files.

Macros available to several workbooks
 

Works wonderfully. Looks like I've found a new toy ; - )

Thanks Tom

"Tom Ogilvy" wrote:

Put you code and userform in an Addin and then create a reference from each
workbook to the addin. This will insure the Addin is loaded when any of the
workbooks are open. Then you would need to add code in the addin to have
the userform behave as you desire.

--
Regards,
Tom Ogilvy


"StephanieH" wrote in message
...
I have 3 seperate reports that all act similarly (tracks the same data for
different departments). I'd like to record one set of macros assigned to
one
userform but available in all 3 reports. What's the easiest way to do
with
without saving the userform and macros in each file? I don't want 3
userforms popping up if they open all three files.