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

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

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

Hi
put the following code in your worksheet event:

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

-----Original Message-----
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


.

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

right click on the sheet tabview codeleft window select worksheetright
window select activateuse

range("a1").select

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

--
Don Guillett
SalesAid Software

"Bob Reynolds" wrote in message
...
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

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

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

"Don Guillett" wrote in message
...
right click on the sheet tabview codeleft window select worksheetright
window select activateuse

range("a1").select

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

--
Don Guillett
SalesAid Software

"Bob Reynolds" wrote in message
...
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

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

glad to help

--
Don Guillett
SalesAid Software

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

"Don Guillett" wrote in message
...
right click on the sheet tabview codeleft window select
worksheetright
window select activateuse

range("a1").select

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

--
Don Guillett
SalesAid Software

"Bob Reynolds" wrote in message
...
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