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" wrote:

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 wrote:

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