protection is not work.

P

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

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
 
G

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
 
P

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
 
P

pure copper

Hi Gord Dibben,

Thanks your guy.

Pure Copper

Gord Dibben said:
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
Click to expand...
 

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

Similar Threads

protection error 2
Not able to unhide sheet in Excel 2002 2
Insert/ delete row in protected worksheet 6
Embed the same Excel multiple times 0
Userinterfaceonly 5
Can I use the subtotal function while a worksheet is protected? 0
Solver Compiler issue 2
Copy protection from one worksheet to another 1

Top