Sharing UserForms/Macros

bpottberg · Mar 12th, 2002, 07:36 AM

I have created a userform to calculate the number of shares in a mutual fund from the % of total holdings. How can I share this with my colleagues?

Thank you

Dave Hawley · Mar 12th, 2002, 07:40 AM

Hi bpottberg

Best way would be to save it as an Add-in (*lxa) then install it like a standard Excel add-in, eg Tool>add-ins | Browse

bpottberg · Mar 12th, 2002, 07:45 AM

Thanks,

I have saved it as an add-in and opened a new WB and included it, but....

How can this be called from the workbook?
As you can tell I am relatively new to this.

Tks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:36 AM	#1
bpottberg New Member Join Date: Mar 2002 Posts: 4	I have created a userform to calculate the number of shares in a mutual fund from the % of total holdings. How can I share this with my colleagues? Thank you

Mar 12th, 2002, 07:40 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi bpottberg Best way would be to save it as an Add-in (*lxa) then install it like a standard Excel add-in, eg Tool>add-ins \| Browse

Mar 12th, 2002, 07:45 AM	#3
bpottberg New Member Join Date: Mar 2002 Posts: 4	Thanks, I have saved it as an add-in and opened a new WB and included it, but.... How can this be called from the workbook? As you can tell I am relatively new to this. Tks.