LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening on a specific worksheet Tim Excel Discussion (Misc queries) 3 May 18th 10 12:31 PM
Opening specific worksheet from hyperlink more questions lots of questions Excel Discussion (Misc queries) 0 May 30th 07 09:53 PM
opening a worksheet at a specific point crusty53 New Users to Excel 13 August 17th 06 05:12 PM
Opening specific worksheet from hyperlink AndrewMead Excel Discussion (Misc queries) 4 July 28th 05 08:58 AM
Displaying a specific worksheet on opening application John Excel Programming 1 February 19th 04 12:27 PM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"