Checkbox help

[LSpliff]

Hi all... I needed to do some stuff for my job but I'm VB inept. What i need is a check box that, when unchecked, it renders lets say A35 to J46 inactive and greyed out where they cant enter any fields. Then when they check it, it opens up the fields. To make matters worse, I hardly use VB and I'll just say I know how to open the editor lol I only have 2 years of C++ under me =oP

If anyone wants to take the time to help me it would really be appreciated!

 

[Smitty]

By default, all cells are locked. With the sheet unprotected, you can CTRL+A (Select All), then Format-->Cells-->Protection-->Uncheck Locked.

Then only the cells in your code range will be affeected.

Smitty

 

[LSpliff]

PERFECT! That was it. Thanks a ton for the help!