Disable/Enable a rountine

[jevicha2]

The attached has what I need. I sent this in another time for another reason, but just can't stop adding new ideas to my program, so here it is again and I would like to know how to disable or enable a routing. I think the attached is well explained. If not then you know I ain't no expert on Excel.

Thanks to Dangler for his solution to the original file.


Jerry

[Bo_Ry]

There are so many ways to do this.

This is one from many.

Please Login or Register  to view this content.

[jevicha2]

Bo_Ry, that works, but could you tell me what [N1:01] does?

Thanks

Jerry

[Bo_Ry]

Short term for Range("N1:O1")

https://docs.microsoft.com/en-us/off...rtcut-notation

[jevicha2]

Ok, copied it over to my main program and found that my Yes and No drop-down had to be capitalized so it would match the subroutine you wrote where they were in all CAPS. Why is that? Maybe this is why I was having so much trouble with Validations. BTW, I figured out what the [N1:O1] was used for. My fault.


Thanks for your help.

Jerry

[Bo_Ry]

By default, VBA is case-sensitive.

Please Login or Register  to view this content.

Put Option Compare Text To make case-insensitive.

Please Login or Register  to view this content.

or change all text in lower case

Please Login or Register  to view this content.