Macro to Hide Excel Sheet + Macro to create a Default sheet
Posted by Mac on November 02, 2001 6:56 AM
I have 10 worksheets in an Excel 2000 WorkBook. One is named "Info Sheet" and the rest are named "Sheet 1", "Sheet 2",...,"Sheet 9". I want a Macro that hides the "Info Sheet" before a certain date MM/DD/YYYY (and shows all the other sheets), and hides all the other sheets after date MM/DD/YYYY (and only show "Info Sheet"). I also want the Macro to execute automaically once a user opens the File/WorkBook.
I also want a macro that makes a Sheet the DEFAULT sheet of a Workbook (i.e. everytime I open the Workbook it opens at that worksheet). I want my workbook to use the CoverSheet as the default sheet.