Protected Workbook Open, Odd worksheet size

[Neal Zimm]

My first experience with protecting and opening a protected workbook.
- In my app, I open two workbooks, one of which is protected.
- After opening, when selecting the protected window, the sheet is about
5/8 the size of the screen, as if it were partially minimized.
- I manually unprotected the workbook, and, pop, the screen looked
normal.

?? Will I have to put code in the workbook open event to do this or is there
another way? I don't recall doing anything special after protecting the
workbook
and then saving it.

Thanks.

 

[NickHK]

Neal,
When you protect the workbook, you have 2 options ; Structure and Window.
If you deselect the Window check box, then save, does that help ?

NickHK

 

[Guest]

Yeah, thanks nick, i remembered after I made the posting here.
--
Neal Z

Neal,
When you protect the workbook, you have 2 options ; Structure and Window.
If you deselect the Window check box, then save, does that help ?

NickHK