Thread: When opening a worksheet I want it to go to a specific cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Reynolds[_3_] Bob Reynolds[_3_] is offline
external usenet poster
  
Posts: 34
Default 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


Reply With QuoteReply With Quote