why not just unhide the sheet as part of the macro and have a macro that upon closing the file the sheet is automatically hidden again?