FoeHunter
Board Regular
- Joined
- Nov 12, 2008
- Messages
- 236
I have a macro that runs four other macros that reads as follows:
Because all of these can take up to 3 or 4 minutes to run (well over 7k cell updates) I want to include some sort of a status bar to show a percent complete so they don’t think Excel froze or the computer quit responding. I didn't want to make this a moster sized post so I didn't include the other 4 macros. Is this possible to do with VBA?
PHP:
Sub Run_All_Calculation_Macros()
' Runs all macros to update values
UTC_UMD_Update
DAV_UMD_Update
DAV_UTC_Update
Totals_Update
Sheets("Quick Copy").Select
Range("T1").Select
End Sub
Because all of these can take up to 3 or 4 minutes to run (well over 7k cell updates) I want to include some sort of a status bar to show a percent complete so they don’t think Excel froze or the computer quit responding. I didn't want to make this a moster sized post so I didn't include the other 4 macros. Is this possible to do with VBA?