Runtime error with vba and checkbox
Dave Peterson wrote:
I thought you used the checkbox from the control toolbox toolbar and placed it
on a worksheet.
If you did, then this code is under the worksheet that holds that checkbox. And
the Me. refers to that worksheet.
If you used a checkbox from the Forms toolbar, try changing all the "Me."'s to
"Activesheet." (include the trailing dot).
Ok, I changed them out and am still getting an error.
Object doesn't support this property or method
with the following line highlighted:
myRng.Locked = ActiveSheet.CheckBox1.Value
I do apprecioate the help you have given.
-Robert Lizak-
|