I have 6 worksheets in an Excel Workbook. When on click on the "X" to close
the workbook I want a macro to automatically run that hides 3 of the 6
worksheets. Any ideas on how to do this?

thanks