How to activate/de-activate a cell based on the selection of a check box

Hi Forum,

Excel version : Excel 2003

I am new bee to excel and need some assistance from the forum with some of my doubts.

My question is : How to activate/ De-activate a cell based on the check box selection.

I will elborate my question as follows :

I am having two work sheets. On the first work sheet, I am having two check boxes, Name and Age and on the second worksheet I am having two cells Name and Age.

If the user selects the Name check box on the first sheet, only the name field needs to be in the active mode and the age field need to be in diasble mode on the second sheet. The same should apply if the user selects the Age check box.

Could some body assist me by explaining the steps to proceed with this scenario.

Eagerly Awaiting reply
KK

Check this link out

http://www.excelforum.com/showthread...ht=check+boxes

Originally Posted by keithl816

Check this link out

http://www.excelforum.com/showthread...ht=check+boxes

Hi keith,

Thanks for your information.
I had included the code which is posted on that thread and changed my work ,sheet attributes as per the code. But, still no luck. Could you please have a look at my work sheet which I had attached to this thread.

Thanks for your help and time in advance.

Waiting for your reply.

Cheers,

krishna Kanigelpula.

Hi Mudraker,

Thanks for your response.

I am using the Visual basic tool bar check box. Please find the attachment which I had uploaded in my previous thread.

I had included the code suggested by one our forum members keith. I think I need to get to a point where I have to change some thing in the code which I am not aware of.

Could you please have a look at it and suggest provide me any help.

Thanks for your help in advance.

Cheers,

Krishna Kanigelpula.

Hi, Krishna. The problem was due to the check boxes and unprotect ranges being on different sheets. I have corrected the issue.

HTH

Jason