Change State of Form Control Checkbox

[hnguy71]

Hi all.

I'm having an error 91 for a macro on disabling the form control checkbox when checked to true.
So what should happen is when the form control checkbox is checked the checkbox itself will now be disabled and this should be called for any instance of any checkbox in the sheet.

Any help would be appreciated!

Please Login or Register  to view this content.

[Norie]

You never set chk to reference, well, anything.

[hnguy71]

Please Login or Register  to view this content.

Yeah, lol. So, I've come up with this solution and it works as I would like it to but I'm wondering if it would slow down my spreadsheet in any way if, let's say, I have 10,000 checkboxes?

[romperstomper]

If you have 10,000 checkboxes, I think you're using the wrong application.