I have a spreadsheet with a fairly complex series of macros that create
reports. These macros take several seconds to run and pull data from several
sheets. Is there a way to mask that process from the user with a page that
shows while the macros are running rather than seeing the data being
filtered, sheets being added etc ?

Thanks in advance,
Chaz