Macro\VBA? to Switch Sheets

**manny_cb** · 09-01-2009, 03:23 PM

I am making sort of a presentation in excel. I was hoping I could make arrows buttons to switch between sheets. So my question would be what would be the vba to goto the next sheet? I know i can use macros and goto specific named sheets but then id have to make a seperate macro for each sheet . Any help is appreciated . Thanks

**martindwilson** · 09-01-2009, 03:37 PM

just hyperlink to sheet
if you put a shape in say a block arrow
select shape
then insert/hyperlink to named location in file

**DonkeyOte** · 09-01-2009, 03:46 PM

Not trying to be "funny" but if you intend to click on a button to go to the next sheet why not just click on the tab itself ? Both actions require the same amount of interaction... one doesn't require VBA.
(or use even CTRL + PAGE UP / PAGE DOWN)

**Palmetto** · 09-01-2009, 04:00 PM

Or:

1. Right-Click on the worksheet navigation arrows at the lower left and choose from the pop up list of worksheets

2. Name a cell on each sheet, then use the Name Box to drop down and pick the named range for that sheet