I am just learning VBA so please be gentle with my stupid question!
I am developing an 'excel application' to assist in the manual parsing of some data. I need to implement a number of functions, such as file import, split columns etc. Generally I have a good handle on what I need to do as far as programming these functions is concerned.
I have developed several macros (VBA procedures). As far as I understand it these macros are stored in the .xls file where I created them. If I refer to these macros in the future in another .xls file then excel loads them from the original .xls file (is this correct?)
I have now created a new tool bar and menu items linked to these macros. My expectation was that the menu items would be stored in the .xls file together with the macros. Not so. If I open a different .xls file the menu items are still visible.
So my question is in two parts.
1. Where are the settings for the excel toolbar and menu items stored?
2. How can I deploy this 'application' along with the toolbar modifications to other people?