View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Protected Workbook Open, Odd worksheet size

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


"NickHK" wrote:

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

"Neal Zimm" ¼¶¼g©ó¶l¥ó·s»D:%23%23su9ik4GHA.696@TK2MS FTNGP06.phx.gbl...
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.

--
Neal Zimm