Shading & Inactivating cells via check box

[Christy Corum]

I have a spreadsheet where there is an active controls checkbox in a portion of the spreadsheet on the first tab. I would like it to be that, if selected (checked), then the cells on the second tabbed worksheet would be disabled. Any way to do this? I am not familar with VBA. Alternatively, if I remove the check box and ask the user to enter Y for yes and disable the second worksheet?

Thanks in advance for the help.

[teylyn]

Hello Christy, welcome to the forum. In case you're wondering why you have not received any response to your question: you posted in the Outlook forum. I have moved your post to the Excel Programming forum.

Next time you post, please make sure you are in the appropriate forum before hitting the "New Thread" button.

thanks.