I'm looking for the best way to allow a user who doesn't know VBA to start up different series of macros.
The big picture is a group of users have to create their own budget forecast. There are multiple phases involved, and multiple steps in each phase. Phase 1 is creating a Staffing forecast, and all the steps to creating it I can do in a series of macros, initiated by the user selecting options from a drop down box. Once it's created, that forecast will be used to drive the creation of other forecasts for travel, supplies, etc.
The problem is this; once the Staffing forecast is created the user will need to eyeball it and make adjustments for things that can't be automated (ie his boss told him this morning that 20 unfilled Widget Maker positions aren't going to be filled, ever). I want the user to be able to make his changes to the staffing forecast and then start the next series of macros (for instance, to create his travel forecast). How do I put a "Go" button of some kind on his sheet to allow him to simply start the next series of macros? And there will be other instances where he'll need to stop at some point in the forecast creation to tweak a particular forecast, so I'd need to again be able to resume the macros after a pause for tweaking.
I'm open to any ideas, and appreciate all the help I've gotten from this group in the past. I'm hoping for a miracle here!
Bookmarks