Hi, I am new to VBA for Excel. I need to create a custom VBA application that runs in Excel. I will be having a lot of separate data files (workbooks), though only one will be loaded at a time in Excel.
The VBA application would customize the toolbars and the Ribbon, till the time the application is removed or Excel is quit.
My question is, where do I keep my VBA code? I don't want the code being replicated in every workbook since it is a waste of disk space. Also if I make a change to the code, it should get reflected for all workbooks that use the application.
I have read something about add-ins, but I am not sure if that's the way to go. In my current template workbook, I have VBA procedures under ThisWorkbook, Sheet1, etc to handle events associated with them. Now if I have the code sitting somewhere other than these locations, will I still be able to handle those events for the actual workbook I will be working with?
Thanks for any suggestions.
Shankar