Worksheet calculate event

[sherry_1991]

Worksheet calculate event doesn't let me change values on another sheet "Queries". When I do gives me error 438, object doesn’t support this property or method.

Please Login or Register  to view this content.

[Norie]

I don't think it's the calculate event preventing you doing it.

What you need to do is reference the shapes on the other sheet and not use Selection.

Please Login or Register  to view this content.

[sherry_1991]

Oh yea I was trying to do it but lack of knowledge prevented me. BUT YES THIS WORKS!!!!!!! AW YEAH! Thank you so much Norie. I really hope i don't encounter a problem now.