Here's how you can unhide your very hidden worksheet in Excel:
- Open your Excel workbook and go to the View tab on the ribbon.
- Click on the Unhide button in the Window group.
- In the Unhide dialog box, you should see a list of all hidden sheets in your workbook.
- Select the sheet you want to unhide and click OK.
- If the sheet is still not visible, it may be very hidden. To unhide a very hidden sheet, you'll need to use VBA (Visual Basic for Applications).
- Press Alt + F11 to open the Visual Basic Editor.
- In the Project Explorer window, find the workbook that contains the hidden sheet.
- Double-click on the ThisWorkbook module to open it.
- Paste the following code into the module:
Formula:
Sub UnhideSheet()
Sheets("xlSheetVeryHidden").Visible = True
End Sub
- Replace "xlSheetVeryHidden" with the name of your hidden sheet.
- Press F5 or click the Run button to execute the code.
- Your hidden sheet should now be visible.
As for your personal worksheet with macros, you can unhide it using the same steps above. If it's still not visible, make sure you're looking in the correct workbook and that the sheet is not protected. If it is protected, you'll need to unprotect it before you can unhide it.