Relation between hide(orunhide) and protect

[clara]

Hi all,

What is the relation between hide(or unhide) and protect(or unprotect)? I
can change a worksheet'visible through immediate window without unprotecting
a protected sheet,but why the hide or unhide submenu is grayed out when the
worksheet is protected.

Clara

 

[Jim Rech]

When I protect a worksheet via Tools, Protection, Protect Sheet and go to
Format, Sheet I find that Hide is not grayed out.

Protecting the workbook structure however does have this effect, as it
should.

--
Jim
| Hi all,
|
| What is the relation between hide(or unhide) and protect(or unprotect)? I
| can change a worksheet'visible through immediate window without
unprotecting
| a protected sheet,but why the hide or unhide submenu is grayed out when
the
| worksheet is protected.
|
| Clara
| --
| thank you so much for your help

 

[Dave Peterson]

Excel has different levels of protection.

1. You can protect the workbook from opening (via File|SaveAs|Tools)
2. You can protect the workbook so that sheets can't be renamed/moved/deleted
or added (via Tools|Protection|Protect workbook). You can also protect the
windows under this so that they can't be resized.
3. You can protect the workbook's project (where macros live)
4. You can protect each sheet, too (via tools|protection|Protect sheet)

And you can hide different things in excel, too.

1. You can hide a window (via Window|Hide)
2. You can hide a sheet (via Format|sheet|hide)
3. You can hide rows or columns (via format|Row (or Column)|Hide)

If you protect the worksheet (#4) (with no special allowances), then you can't
hide or unhide columns or rows.

If you protect the workbook's structure (#2), then you can't hide any sheet.

And even with no protection at all, there has to be at least one sheet visible.

So which level of protection did you try and which level of hiding did you try?

 

[clara]

Dear Dave,

Your explanation is wonderful. My workbook has two sheets shown and one
hidden, the workbook is protected. Before I print the hidden sheet out, I set
the sheet's Visible = true, but I got "Class method failed "message, now I
know I have to unprotect the workbook first.

Thank you very much!

Clara

 

[clara]

Hi Dave,

How can I protect a workbook's project, I tried the Tools menu in VBE, but
nothing happend. Could you tell me how to do it and can I prevent uses see
macro's code?


Clara

thank you so much for your help

 

[Dave Peterson]

Inside the VBE.

Select your workbook's project.
Tools|VBAProject Properties|Protection tab.

This password is easily bypassed, too. But it'll stop lots of people (not
all!).

Hi Dave,

How can I protect a workbook's project, I tried the Tools menu in VBE, but
nothing happend. Could you tell me how to do it and can I prevent uses see
macro's code?

Clara

thank you so much for your help