Protect only hidden column - Possible??

[ntruong]

Dear Experts,

Is there a way to password-protect a hidden column without having to protect the whole worksheet. My goal is people should be able to make other changes but they cannot open the hidden column.
Can a macro or VB code does it?
Thanks a lot,

Nee

 

[Ekim]

Non-VBA:

Select all cells in the sheet by:
1. Clicking the “Select All” button (the button at the intersection of row numbers and column letters); or
2. Ctrl-A (hold down the Ctrl key and then hit the A key).

Go to the Format menu | Cells | Protection Tab
Remove check from Locked
OK

Select the column you want to lock
Go to the Format menu | Cells | Protection Tab
Place check in Locked
OK

Hide the selected column.

Go to Tools menu | Protection | Protect Sheet
Enter a Password
OK
Confirm Password
OK

Because you have removed the locked status from all cells (step one), protection will not effect entry to the worksheet with the exception of the selected column (which is hidden anyway).

Regards,

Mike

 

[ntruong]

Mike,
Thanks for the tip.
However the challenge is how to protect only selected columns with a password from a protected worksheet without a ps.
The goal is for employee to make format changes as they wish but they cannot open the password-protected columns.

Again, I wonder if excel can do something like this.

Please shed some light. Thanks.

Nee

 

[Von Pookie]

Continued here:
http://www.mrexcel.com/board2/viewtopic.php?t=77139