• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to move between worksheets

A

akn

New Member
I'm trying to create a macro to move between worksheets. I can create a macro to move to a single worksheet, and so could create macros to move to every worksheet individually, but I am wondering if someone could help me with one that could just move to the next worksheet to the right. I.E. move from sheet 1 to sheet 2, then to sheet 3 etc.
 
I'd suggest reading one of Debra's articles about setting up these kinds of toolbars.

For Excel 2003:

http://www.contextures.com/xlToolbar01.html


For Excel 2007:

http://www.contextures.com/xlToolbar01b.html
 
Thanks, I think that could be useful. Realistically though I don't know if I have enough sheets that a toolbar is necessary, I'm trying to create something more like Ctrl+Tab in a web browser to simply move from one worksheet to the next. I avoid using a mouse as much as possible, so something more like that would be much more useful to me.
 
Ditto to what Jason said. If you just need some keyboard shortcuts,

Ctrl+Page Up/Down = change worksheet

Alt+Page Up/Down = horizontal scroll of worksheet
 
HA! i work over by the old airport! right off Sam Jones Expressway!


so you ARE literally watching me!! thats how you always beat me to a post!!
 
You must log in or register to reply here.
Back
Top