I have a command button which calls macros in other worksheets. The
screen does not update until the macros are finished. These macros take
some time to run, after which I switch to a final worksheet showing the
results:

Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Call macro1
Call macro2
Application.ScreenUpdating = True

Worksheets("Results").Activate
End Sub

I wish to make the command button 2 flash while the calculations in the
2 macros are running.

Can anyone please assist with this?


--
JoeS01
------------------------------------------------------------------------
JoeS01's Profile: http://www.excelforum.com/member.php...fo&userid=9816
View this thread: http://www.excelforum.com/showthread...hreadid=382707

I suggest forgetting the flashing command button. This would take some fancy
API code and would probably look goofy anyhow. I suggest a progress bar
instead. Rob van Gelder has a couple listed at his site. I have my own
version. His are likely more appropriate for your purposes.

http://homepages.paradise.net.nz/~robree/excel/

Regards,
Greg




"JoeS01" wrote:


I have a command button which calls macros in other worksheets. The
screen does not update until the macros are finished. These macros take
some time to run, after which I switch to a final worksheet showing the
results:

Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Call macro1
Call macro2
Application.ScreenUpdating = True

Worksheets("Results").Activate
End Sub

I wish to make the command button 2 flash while the calculations in the
2 macros are running.

Can anyone please assist with this?


--
JoeS01
------------------------------------------------------------------------
JoeS01's Profile: http://www.excelforum.com/member.php...fo&userid=9816
View this thread: http://www.excelforum.com/showthread...hreadid=382707