Les,

Try something like the following:

UserForm1.Show vbModeless
AppActivate Application.Caption


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Les" wrote in message
...
Hi

As subject - have tried ActiveCell.Activate and all sorts of
other
things in all sorts of event procedures and nothing seems to
work.
Is there a single line of code that will force the focus back to
the sheet from which the UserForm was 'shown' (via a button
click)?

I just want to click on the button and have the focus returned
back to the cell that was active at the time of the UserForm
opening.

Have also tried making ALL controls on the UserForm have no
TabStop, or no TakeFocusOnClick - all to no avail - I'm at the
absolute end of my tether with regard to what else to try.

I must be missing something.

regards,
--
Les Hay, Livingston. Scotland