Option to time-delay auto open and open worksheets (not the VBA code) for editing
Posted on 2006-06-26
I have a fully automated macro running under This Workbook so it runs when the Workbook is opened. The workbook is opened by call from the XP Task Scheduler and runs at 3:00 am weekdays. It runs perfectly, does its stuff, then closes and quits Excel. I want to give the clerk the opportunity to open the workbook, make edits to the static data in it, then save and close - without running the VBA code or having to hold the Shift key down when opening the file to prevent the auto run from firing. She should be able to click on the workbook's shortcut on her desktop, have the auto run on timed delay, give her 10 seconds to click on a message box and open the sheet for edit, or, when it runs at 3:00 am, it will execute automatically after 10 seconds. Ideally, I'd like the edit option, if she takes it, to follow with menus asking what part number, etc., she wants to add/delete/change, and then do it and gracefully close.
Is it possible and/or straight-forward to add this functionality in my VBA code? Getting the auto run code to do the multitude of gymnastics it does was phase one. Now that it's running, the client wants to have this edit option available on demand, and like all clients, they're in a hurry. Thanks for the EXPERT help, folks. EE is awesome!