Results 1 to 17 of 17

Pause and resume between series of macros

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Pause and resume between series of macros

    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!
    Last edited by jomili; 09-17-2010 at 10:36 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1