at the top of the userform module

Dim sh as Worksheet

in the initialize event

set sh = Activesheet

in the code that closes the userform

sh.Activate

--
Regards,
Tom Ogilvy

"Denny Behnfeldt" wrote in message
...
I have a Userform that is activated from one toolbar while any of 7 sheets
(MON, TUE, etc.) is active. When the Userform is done doing it's work and
is
closed, I want to return to the sheet from which it was launched. Any
ideas
on how I would do this?

This newsgroup is incredibly helpful!
Thanks alot,
Denny