Hiding Worksheets - Problem with Posts

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
You also protected the Windows option (along with Structure).

Unprotect the workbook, and then reprotect it. But don't check that windows
checkbox.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Worksheets & Formulas 1
Protect Workbook 4
How to password Protect when WORKSHEET is Very HIDDEN 5
Hide AutoShapes On Excel Worksheet 5
Hide a sheet with a variable name 4
Hiding columns in Excel 2003 2
Password protecting worksheets 1
Hiding a worksheet while formatting it 2

Back
Top