protection is not work.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pure copper - 11 Feb 2008 23:35 GMT

I created an excel file and set two colmumn on one worksheet to hide ,and
then set protection on the worksheet. those two colmumns are refered by other
worksheet.
My problem is that user can unhied the protected colmumns. Protection is not
working. Is there anybody know this issue?Please help me out.

Reply to this Message

Tyro - 12 Feb 2008 00:18 GMT

You have to protect the workbook and protect its structure. You don't state
what version of Excel you are using.
In Excel 2007- Review - Changes - Protect Workbook - Check Protect Structure
and Windows

Tyro

>I created an excel file and set two colmumn on one worksheet to hide ,and
> then set protection on the worksheet. those two colmumns are refered by
[quoted text clipped - 3 lines]
> not
> working. Is there anybody know this issue?Please help me out.

Reply to this Message

Tyro - 12 Feb 2008 00:26 GMT

I think in earlier versions of Excel, protection is under
Tools/Protection/Protect Workbook.

Tyro

> You have to protect the workbook and protect its structure. You don't
> state what version of Excel you are using.
[quoted text clipped - 10 lines]
>> not
>> working. Is there anybody know this issue?Please help me out.

Reply to this Message

pure copper - 12 Feb 2008 20:08 GMT

Hi Tyro,

Thanks for your reply. I am using Excel 2007. I will try your suggestion and
see if it works.

Pure copper

> You have to protect the workbook and protect its structure. You don't state
> what version of Excel you are using.
[quoted text clipped - 10 lines]
> > not
> > working. Is there anybody know this issue?Please help me out.

Reply to this Message

Gord Dibben - 12 Feb 2008 00:23 GMT

If using Excel 2002 or 2003 you can set options when protecting.

You may have checked "format columns" when protecting.

Gord Dibben MS Excel MVP

>I created an excel file and set two colmumn on one worksheet to hide ,and
>then set protection on the worksheet. those two colmumns are refered by other
>worksheet.
>My problem is that user can unhied the protected colmumns. Protection is not
>working. Is there anybody know this issue?Please help me out.

Reply to this Message

pure copper - 12 Feb 2008 20:11 GMT

Hi Gord Dibben,

Thanks your guy.

Pure Copper

> If using Excel 2002 or 2003 you can set options when protecting.
>
[quoted text clipped - 7 lines]
> >My problem is that user can unhied the protected colmumns. Protection is not
> >working. Is there anybody know this issue?Please help me out.

Reply to this Message