Hi I'm after a macro so that when a sheet is selected it updates the external links and comes up with a message that say "Updating values - please wait". I would then like the message to disappear when the links have finished refreshing.

Many thanks