Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I wish to call a sub from an add-in

Status
Not open for further replies.

simoncpage

Programmer
Apr 4, 2002
256
GB
I wish to call a sub from an add-in in a new worksheet,

I could simply click asign macro and type in the name and it works a treat however I wish to pass some other arguments and I want to call it from a module in the new worksheet (but with having to add in the path of the add-in - ideally I would like to put Name_of_addin.xla!SUB_TO_RUN - but this doesn't work)

Can any one help me please?

Thanks

Simon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top