LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default One Single Message Box for chained macros

I have several macros which are all to do with file generations. They all
begin with a message box asking for a date. The resulting filenames depend
on the date entered, e.g. "macro1 02/02/04", "macro2 02/02/04". I have
written a master macro chaining these macros together. The hassle is when
the master macro is run, I'd be prompted by the various message boxes which
belong to the individual macros. Is there anyway I can put some code in the
master macro so that when the message boxes come up, they'd all get the same
date? Obviously I don't want to change the individual macros because they
are still needed as standalone macros from time to time.

TIA.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Document contains macros message april Excel Discussion (Misc queries) 8 March 12th 08 01:15 PM
Message Pop up Macros penri0_0 Excel Discussion (Misc queries) 5 May 11th 06 03:19 PM
Single message box for multiple IF statements Simon Excel Programming 4 December 4th 03 02:49 PM
Can I "sign" my own macros? or some other fix for the message about security and macros? BruceJ[_2_] Excel Programming 8 November 6th 03 12:46 AM
Pop up message control using macros Pete Davis Excel Programming 2 September 30th 03 03:38 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"