Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Add-in
I am using Ron Debruin's menu system, which is working perfectly, to drive an
application I have developed and have a couple of questions from a housekeeping perspective: The forms and associated code I developed in my application to run the various menu options must now reside in the add-in, is that correct? The modules I developed in my application to run other components (not form related) must now reside in the add-in, is that correct? The sheets that hold the data must sit in the original worksheet, is that correct? If my assumptions are correct, then it means every time I do a system update, I need to redistribute the add-in to all users and get them to copy it to their local drive where their Addins are stored. If I could maintain all the modules, forms, sheets and associated code in my original spreadsheet, which is the one users access to run the system, it would be much simpler to manage the updates as I store that file on a central server. If all I had to do was manage Ron's QAT menu system, which will change very infrequently, via the addin, updating the system would be a breeze. Does anyone have any suggestions that might make things a bit simpler to manage the updates? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 & 2007 menu compatible menu by Ron de Bruin | Excel Programming | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |