Hiding Worksheets - Problem with Posts

[Guest]

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.

 

[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.

 

[Guest]

That worked. Thanks, Dave.

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

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