Workbook protection question

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

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
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top