Unable to get the CheckBoxes Property of the WorkSheet class

[Controller 99]

Hi all

I'm trying to hide rows in one sheet and hide a sheet by ticking a Checkbox. It all worked well untill I protected the Sheets and try to unprotect the adressed sheets with a macro. When un ticking the checkbox everything works well but when I Check it agen I get a error message 1004 stating "...Unable to get the CheckBoxes Property of the WorkSheet class"

This is my code: (I'm farly new at this) Would be vary happy if someone would look at it.

Please Login or Register  to view this content.

[LJMetzger]

Hi Controller 99,

Your code worked for me after I deleted the following line which caused a compile error:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

See the attached sample file.

Lewis

[Controller 99]

Thanks Lewis

I'll use the "Option Explicit" in the future.

Controller 99