Hiding Worksheets - Problem with Posts

J

johnston

I followed the instructions to "Prevent worksheet from opening in a workbook"
(posted 12/12/06 5:04 PM) and ran into a problem. The instructions were

Format>Sheet>Hide
Tools>Protection>Protect Workbook

and to check "structure" and "windows." The worksheet was hidden, but when
I saved, exited, and reopened the file, the visible worksheets were at
half-size. There were no size controls in the top right of the worksheet
window to enlarge it. I'm using Excel 2003. How can I fix this?

Thanks.
 
D

Dave Peterson

You also protected the Windows option (along with Structure).

Unprotect the workbook, and then reprotect it. But don't check that windows
checkbox.
 
J

johnston

That worked. Thanks, Dave.

Dave Peterson said:
You also protected the Windows option (along with Structure).

Unprotect the workbook, and then reprotect it. But don't check that windows
checkbox.
Click to expand...
 
Top