Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default Switching Sheets

I have a button on one and I called it "NEXT", because I want to go to the next sheet.

I can go to the next sheet but I can make it go to the top of the shhet.

How can I do this?

ROGER
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default Switching Sheets

Hi Roger

you need the line
Range("A1").select
in after you go to the new sheet

Hope this helps
Cheers
JulieD

"RogeR" wrote in message
...
I have a button on one and I called it "NEXT", because I want to go to the

next sheet.

I can go to the next sheet but I can make it go to the top of the shhet.

How can I do this?

ROGER



Reply
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
Switching between sheets in same workbook (Like Alt + Tab & Choose nils Excel Discussion (Misc queries) 4 April 17th 10 12:12 AM
shortcut key for switching sheets wb198 Excel Discussion (Misc queries) 2 February 1st 08 05:34 PM
switching between sheets using the keyboard amirasherif Excel Discussion (Misc queries) 3 January 15th 08 03:14 PM
short cut key for switching between sheets in a workbook? RH Excel Discussion (Misc queries) 4 January 3rd 07 05:19 PM
Switching between sheets in same window... Kojones Excel Discussion (Misc queries) 1 July 16th 05 10:16 PM


All times are GMT +1. The time now is 09:19 AM.

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"