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

B

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
 
F

Frank Kabel

Hi
put the following code in your worksheet event:

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

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.
 
B

Bob Reynolds

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