Hiding Worksheets - Problem with Posts
 

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

FormatSheetHide
ToolsProtectionProtect 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.

Hiding Worksheets - Problem with Posts
 

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

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

johnston wrote:

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

FormatSheetHide
ToolsProtectionProtect 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

Hiding Worksheets - Problem with Posts
 

That worked. Thanks, Dave.

"Dave Peterson" wrote:

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

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

johnston wrote:

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

FormatSheetHide
ToolsProtectionProtect 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