To view the content of a hidden workbook, follow these steps:
Step1: On the Window menu, click Unhide.
Notes:
- If the Unhide command is unavailable, the workbook does not contain hidden sheets.
- If both the Rename and Hide commands are unavailable, the workbook is protected from structural changes. You'll need to remove protection from the workbook to determine whether sheets are hidden; removing protection may require a password.
- To remove protection from the workbook: On the Tools menu, point to Protection, and then click Unprotect Workbook.
If prompted, enter the password assigned when the workbook was protected. Passwords are case sensitive. You must type the password exactly as it was created, including uppercase and lowercase letters.
No comments:
Post a Comment