ExcelBanter - View Single Post - When opening a worksheet I want it to go to a specific cell

Don Guillett[_4_]

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