I did a forum search looking for suppressing startup macors with no success. I need to learn more about searches, I am sure.

I send an energy report to a gentleman in our corporate offices. Unfortunately he has trouble with anything beyond simple point and click, including understanding when to allow update links and when to not allow update links.

My workbook has eleven worksheets, one for each factory location and I have a Worksheet_Activate() macro for each sheet to do some automatic scaling of charts to take into account changes in minimum, maximum, and stDev changes that may have been updated via links. No big deal for me.

But he wants the charts and graphs and the data without the formulas and links to other workbooks. He says every time he opens one of my workbooks he loses the data, he can see it while the update links dialog is there, but no matter whether he says OK or not, the data goes away after he opens the workbook.

I created a copy of the workbook and a macro to loop through each sheet on the original, copy the sheet, and paste values on the copied workbook sheets.

What is the best way to suppress the Worksheet_Activate() macros while looping through and copying and pasting the worksheets?