activate worksheet and cell

[mikej336]

I have a button on my screen. Once I press the button I want to return to the last cell I was in.

I have tried

Sheets("sheet1").Select
Cells(myrow, mycol).Select
Cells(myrow, mycol).Activate

but when I push the button the button remains the focus?

Any thoughts?

Thanks

Uncle Mike

 

[Loomah]

set the button's "Take focus On Click" property to false

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​