Popup MsgBox

[jackle]

Is there a way to create a MsgBox that pops up when a Refresh All is
complete? If so, can you send code? When we pull data into worksheets from
the SQL server, it takes a while. You are constantly looking at a cursor
(curse-err!!) to see if it's complete. A pop up would be nice. Thanks in
advance.

 

[exceluserforeman]

Create a macro that executes the Refresh All then at the end of the sub ...
assign it to a toolbar button


Sub Do_It_To_Me ()
Application.RefreshAll
msgbox"All Done!",vbexclamation,"Refesh Manager"
End sub