Microsoft Office Tutorials and References
In Depth Information
Clicking the Hide button conceals any open window. However, if you have multiple
windows open for the same workbook, clicking the Hide button hides only the active window.
The entire workbook isn’t hidden. For more information, see “Opening multiple windows
for the same workbook” earlier in this chapter.
Nothing happens when I try to open a workbook
If, when you try to open a workbook, you don’t see any error messages or dialog boxes
but the workbook doesn’t appear to open, the window was probably hidden when the
workbook was last saved. The workbook is actually open; you just can’t see it.
If, in a previous Excel session, you clicked the Hide button on the View tab and then
forgot about the hidden window when you exited Excel, you probably saw a message
like “Do you want to save changes you made to Book1?” This refers to the hidden
file—the change you made was the act of hiding it. The next time you open the file, it
appears that nothing has happened, but if you look at the View tab, the Unhide button
is active, which happens only when a hidden window is open in the workspace. Click
the Unhide button, select the file name to make it visible once again, and then save it
before exiting Excel.
Protecting a workbook not only prevents changes to the complement of worksheets
contained in the workbook, but it can also prevent modifications to the way the workbook
windows are displayed. To protect a workbook, click the Review tab, and click Protect
Workbook to display the dialog box shown in Figure 7-10.
Figure 7-10 Clicking Review, Protect Workbook helps insulate your workbooks from inadvertent