Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to read own posts or replied Posts | Excel Discussion (Misc queries) | |||
Hiding worksheets | Excel Discussion (Misc queries) | |||
Hiding worksheets | New Users to Excel | |||
Hiding worksheets? | Excel Discussion (Misc queries) | |||
hiding worksheets | Excel Worksheet Functions |