How do I lock hidden columns?
 

How do I make absolutly certain that no one can unhide any hiddend coulmns in a worksheet? These columns are part of a price list and it is vital that no one can access it. I did protect the sheet and workbook, but I am still able to unhide the columns.

I am not an Excell expert so please explain in plain english!

Regards Henk

--
Message posted via http://www.officekb.com

Hi Henk

Try this in a blank new sheet:

Cell A1: You're the
Cell B1: silly
Cell C1: man !

Hide column B. You should read "You're the man !" , right ?
Now copy range A1:C1. Paste in another location.

Keep confidential information out of the file ! If it's in there then it's
accessible.

HTH. best wishes Harald

"Henk Neuhoff via OfficeKB.com" skrev i melding
...
How do I make absolutly certain that no one can unhide any hiddend coulmns
in a worksheet? These columns are part of a price list and it is vital that
no one can access it. I did protect the sheet and workbook, but I am still
able to unhide the columns.

I am not an Excell expert so please explain in plain english!

Regards Henk

--
Message posted via http://www.officekb.com

Thanks Harald

It worked the way you explained it, my problem is that there is formulas in the hidden columns, so if i hide, then copy them they can still be unhidden in the new sheet. I seem to copy the whole sheet!

--
Message posted via http://www.officekb.com

Hi Henk

What you should do is physically delete everything that should not be seen.
If other cells' formulas are depending on the cells-to-be-deleted, replace
those formulas with values first. Trust me on this, you can not hide
information good enough in an excel file. Excel is not made for that.

HTH. Best wishes Harald