Workbook protection question

  • Follow


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


0
Reply Robert 2/14/2010 2:22:30 PM

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
> 
> 
> .
> 
0
Reply Utf 2/14/2010 3:28:01 PM


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" <nobody@gmail.com> wrote in message 
news:HGTdn.74395$RS6.46351@newsfe15.iad...
> 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
>
> 


0
Reply JLGWhiz 2/14/2010 3:29:41 PM

2 Replies
737 Views

(page loaded in 0.426 seconds)


Reply: