Based on advice from Mr.Tusharm, I am breaking my macro up into separate files: an XLS file for storing local user data, and an XLA file for storing the macro code.
http://www.mrexcel.com/board2/viewtopic.php?t=275429
However, I'm having problems running the macros from the AddIn...
I was under the impression that Subs stored in an XLA module were availible to EVERYTHING. Right now I have buttons on the data XLS that calls the macros in the XLA... and I'm getting "Sub Not Defined" errors. GRRRRR.
Am I suposed to inlcude the AddIn workbook name when I call the Sub?
IE, instead of:
RequestGenerator
RequestForm_Macros.xla!RequestGenerator
Any advice is appreciated.
http://www.mrexcel.com/board2/viewtopic.php?t=275429
However, I'm having problems running the macros from the AddIn...
I was under the impression that Subs stored in an XLA module were availible to EVERYTHING. Right now I have buttons on the data XLS that calls the macros in the XLA... and I'm getting "Sub Not Defined" errors. GRRRRR.
Am I suposed to inlcude the AddIn workbook name when I call the Sub?
IE, instead of:
RequestGenerator
RequestForm_Macros.xla!RequestGenerator
Any advice is appreciated.