shortcut key to switch sheets

Originally Posted by associates

Hi,

I was wondering if anyone might be able to help me here.

I was looking for a shortcut key to switch between sheets in excel spreadsheet. Is it possible?

Thank you in advance

Hi,

If the tab selectors are insufficient, a macro with a shortcut key that increases sheets() by 1 ?

how many sheets do you have?

---

Originally Posted by associates

Thank you Bryan for your reply.

There is only 3 of the sheets, not many of them. It's just that the users would like to use a shortcut key rather than using the mouse to move between sheets.

How do i write the macro to do that?

Thank you in advance

Hi,

in a macro with a Shortcut key, put

Please Login or Register  to view this content.

Let me know how you go

---

Originally Posted by associates

Hi Bryan,

Thank you for your reply.

It works. I created a button and put your code into it. It moved to another sheet. However, do i have to create a button on every sheets and put the codes on each one of the sheets? Sorry i must've missed on something here.
I've never written macros before.

Thank you in advance

Hi.

no


use a Macro shortcut key, CTRL s
etc (a letter of your choice).

In Macros, set the code as a Macro and Options, Shortcut key, lowercase s
then CTRL s will increase the sheet.

hth
---