Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column password protection
Hi,
Is it possible to protect columns in a spreadsheet with a password? I would like to hide the contents in specific columns from unauthorized users. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column password protection
You can not protect specific parts of you worksheet with a password. However
you can lock/unlock specific cells, including whole columns, that when the worksheet is protected (with or without a password); they can/cannot be selected and /or edited. You can of course hide a column which is very different to the above, if you hide and then protect the sheet you cannot unhide. I guess if you do not want the user to see the contents, then hide is the best option. The following will hide column E and then protect the sheet, (you can of course do this manually without using a macro) With Sheets("Sheet1") .Columns("E:E").EntireColumn.Hidden = True .Protect Password:="myPassword" End With -- Regards, Nigel "Anders" wrote in message ... Hi, Is it possible to protect columns in a spreadsheet with a password? I would like to hide the contents in specific columns from unauthorized users. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Password protection | Setting up and Configuration of Excel | |||
Password protection | Excel Programming | |||
password protection | Excel Programming |