Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Workbook protection question

If you press the "Protect Workbook" button you will
see a dialog box with two options: "Structure" and
"Windows".

What does it mean to protect "Windows"???

thankx


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Workbook protection question

Hi,

The 'Windows' bit prevents the resizing/minimising etc of each Window. At
the same time as you select it watch the window minimise/maximise buttons
disappear in the top right corner.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robert Crandal" wrote:

If you press the "Protect Workbook" button you will
see a dialog box with two options: "Structure" and
"Windows".

What does it mean to protect "Windows"???

thankx


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default Workbook protection question

This is from the Excel help file:

To protect the structure of a workbook so that worksheets in the
workbook can't be moved, deleted, hidden, unhidden, or renamed,
and new worksheets can't be inserted, select the Structure check box.

To protect windows so that they are the same size and position
each time the workbook is opened, select the Windows check box.

To prevent others from removing workbook protection, type a
password, click OK, and then retype the password to confirm it.

So apparently, it only affects size and position of the windows if Windows
is selected.




"Robert Crandal" wrote in message
...
If you press the "Protect Workbook" button you will
see a dialog box with two options: "Structure" and
"Windows".

What does it mean to protect "Windows"???

thankx




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Further Protection Question Risky Dave Excel Programming 4 August 19th 08 01:04 PM
Protection Question PT New Users to Excel 1 July 2nd 08 03:57 AM
Protection Question - Help Please baz Excel Discussion (Misc queries) 0 April 7th 08 06:23 PM
Worksheet protection question Dominic Excel Discussion (Misc queries) 3 August 17th 07 07:46 PM
Another cell protection question brodiemac Excel Discussion (Misc queries) 1 August 7th 07 09:20 AM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"