G
Guest
I have a very large spreadsheet which links to over 300 other spreadsheets.
When a specific macro is run to perform a filter there is long delay whilst
it performs it.
I am trying to figure out how to adise the user that there may be a delay at
the begining of the macro in a message box (e.g. "Calculating - please
wait"). At the end of the macro I want the box to close automatically.
Any ideas how I can do this?
Thank you in advance.
When a specific macro is run to perform a filter there is long delay whilst
it performs it.
I am trying to figure out how to adise the user that there may be a delay at
the begining of the macro in a message box (e.g. "Calculating - please
wait"). At the end of the macro I want the box to close automatically.
Any ideas how I can do this?
Thank you in advance.