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.