Apologies, I'll use code tags in the future.

We don't use the hide feature for the reports page because some recipients need to be able to see formulas in case they have questions about the data, which is included on other sheets. The macro also only copies a certain part of the page, which is a convenience for recipients. So there is no reason the VBA code shouldn't be working?