If you encounter the aforementioned behavior, and you try to delete the
inserted Sheet1, you receive the following error message:
A workbook must contain at least one visible worksheet.
To hide, delete, or move the selected sheet or sheets, you must first insert a new sheet or unhide a sheet that is already hidden.
In Excel 2000, you cannot insert new module sheets or unhide module sheets that were inserted into a workbook that was created in earlier versions of Excel. Therefore, you must retain this extra worksheet that is inserted into your workbook. If you insert another visible sheet into the workbook (such as a chart sheet or an Excel 5.0 dialog sheet), you can then delete or hide Sheet1.