Hi,
It think you'll have to pass a parameter to every macro
that tells the macro what to do. You could make the
parameter Optional, i.e.
Public Sub MySub(Optional ShowMsg as boolean = True)
'In this case ShowMsg = True if no parameter was given
'Your code...
If ShowMsg Then
msgbox "Updated!"
End If
End Sub
Hope this help!
/Nicke
-----Original Message-----
Hi,
I consider myself an Excel formula expert, but only
slightly above the
novice level in VBA macros. Here's my problem.
I have a workbook where I've written about 30 different
retrieve macros
(Hyperion Essbase) to update data in different sections
of the file.
At the end of each macro I have a msgbox that basicall
says "data
updated". This is fine for running the macros
individually.
I'm now writing a macro that will call and run all of
the other ones in
a specific order. I don't want the user to have to
click OK 30 times
in order for the macro to continue.
Is there a way to make it automatically clear each box
and continue.
Obviously I could take the msgboxs off of the end of
each individual
macro and it would work, but I'd really like to keep
them their.
Any suggestions?
Thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
.