When opening a worksheet I want it to go to a specific cell

[Bob Reynolds]

Hello,
I'm trying to put vb code into my worksheet where each time a specific
worksheet's tab is selected, when it opens it will automatically go to cell
A1.

I've been all over the help and can't find it to work in my specific
circumstance.
Each time I click on the tab "sheet 1" I want A2 to automatically be the
active cell.

Any ideas?
Thanks
Bob Reynolds

 

[Frank Kabel]

Hi
put the following code in your worksheet event:

Private Sub Worksheet_Activate()
me.range("A2").select
End Sub

 

[Don Guillett]

right click on the sheet tab>view code>left window select worksheet>right
window select activate>use

range("a1").select

If you want for all worksheets, look in the ThisWorkbook module for the same
thing.

 

[Bob Reynolds]

Thanks to both of you,
That's a neat trick that I learned from you, Don. Thanks a lot
Bob

 

[Don Guillett]

glad to help