protection is not work.

[pure copper]

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.

 

[Tyro]

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

 

[Gord Dibben]

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

 

[pure copper]

Hi Tyro,

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

Pure copper

 

[pure copper]

Hi Gord Dibben,

Thanks your guy.

Pure Copper

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