I accidentally posted in the wrong forum first: http://www.ozgrid.com/forum/showthread.php?t=167836
I'm trying to change from mixed code and data to having code and data separate. Excel VBA has been awesome for what we're doing, but I'm starting to have issues when I need to update code with bug fixes etc. I'd like to use an excel add-in for the code on all my company computers and keep customer data in .xlsx formats.
The issue I'm running into is that I've built and used several Button form controls on the excel worksheets i'm using. I'd like to keep using those buttons because all of my employees are trained to use this system and it's easier from a user standpoint than menus or ribbons. however, I don't know a way to connect the buttons to the code in the add-in. I've searched all over the interwebs and no luck yet. I can't be the first person with this issue as I've seen a lot of info on the "coders progression": Data > Data and Code mixed > Data and Code separate.
The only thing I can think of so far is to add a snippet of code to each sheet which directs each button to the add-in subs, but then I can't keep my data in a .xlsx format and it's not truly separated code and data anymore. There must be an easy way!
I'm using Office 2010 on Windows 7 32 bit and 64 bit platforms.