You can set a fully qualified ref to the sheet executing the macro,
at

the top of the macro...



Dim wksCaller As Worksheet

Set wksCaller = ActiveSheet



..so if the macro activates any other sheets during runtime, your
code

will always know which sheet the button clicked is on. (Note that

rarely is it necessary to change sheets!)

Thanks!

That's presently what I do and so far no problems. But is that
really "atomic" so to speak. Can I be sure that while the current
routine is queuing up the sheet remains active? I ran into a
property call parent and am starting to think about that.

Should be no problem so long as the code refs the sheet. There should
be no reason for the sheet to *not* become the active sheet unless your
code deliberately causes that to happen.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com