How to Apply Different Passwords to Each Columns without Protect worksheet?

[Rajeshkumar R]

Hello Friends,

Need your valuable help to achieve subjected Query!

In the attached file, I need four different passwords for Columns D, E, F, & G Respectively.

I had gone though below link and partially I could able to achieve what I need.

http://support.microsoft.com/kb/289270

However, the problem is at the end of this process we have protected the worksheet as well. This is not feasible for the process what I am working on.

So, please do suggest me how to apply different password without protecting worksheet.

Thanks & Regards,
Rajeshkumar R

[Rajeshkumar R]

Hi Friends,

If it’s not possible to achieve subjected target through normal process, we can go for VBA too. That also fairly okay for me.

Kindly help me…. Immediate support and suggestion is really appreciated!

Thanks & Regards,
Rajeshkumar R

[JBeaucaire]

1) Right-click on the sheet tab and select VIEW CODE

2) Paste in the sheet event macro:

Please Login or Register  to view this content.

3) Edit the various passwords for each column

4) In the VBA > Tools > VBAProjectProperties > Protection, click on the [x] Lock project for viewing and add a password of your own. This is to keep users out of the VBA so they can't look up passwords in your code.

5) Close the VBA editor and save.

6) now make some edits on your sheet

[Rajeshkumar R]

Hi JBeaucaire,

Thanks a lot for your instant support, suggested VBA code works outstanding in my worksheet.

However, if you can help me to accomplish below said few corrections in the code (as I have no knowledge regarding VBA), it would really helpful for me!!!

1. Existing VBA is been designed in such a way that for each cell to edit, we are supposed to keep re-enter the password… which is practically not reasonable for a person who is a Manager or above.

Hence… after open the workbook, one time let the person give the password then, till he saves the file… he should be accessible on that particular column. (I would suggest, if we can keep a User form input on the top of each column) to enter password.

2. In existing VBA when we type the password to access the cell, password is visible on input box screen. Instead if we get like ****** or something like that, it would be great.
Once again thanks for your help and looking forward updates from your end!

Thanks & Regards,
Rajeshkumar R

[JBeaucaire]

Here's is an alternate version that will remember after a password is input for a specific column, it won't ask again. Masked passwords are not available with Excel popup messages, they are only available when you construct and use Form controls, I'm not going to build that, sorry.

Please Login or Register  to view this content.

[Rajeshkumar R]

Hi JBeaucaire,

Once again thank you so much for your wide-ranging support and massive thought!

Thanks & Regards,
Rajeshkumar R