| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Workbook Open, Odd worksheet size
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Workbook Open, Odd worksheet size
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" x.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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Workbook Password protected tp open | Excel Discussion (Misc queries) | |||
| Open workbook name size | Excel Programming | |||
| Open workbook that is protected with password | Excel Programming | |||
| Open password protected workbook. | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Linear Mode
