First, let's record a macro of what you want to do (TOOLS | MACRO | RECORD
NEW MACRO). Start on one of the sheets, start your macro recording, click to
the sheet you want to go to (SHEET1), stop the recording. Now go to any
sheet and test your macro. It should take you back to your sheet. Rather
than putting a button on every sheet that calls this macro, you could create
a keyboard shortcut for the macro. This would mean users would not have to
take their hands off the keyboard to click on a button (and you wouldn't have
to create 309 buttons). To create the keyboard shortcut after you have
created the macro, simply choose TOOLS | MACRO | MACROS then click on the
OPTIONS button and choose your shortcut. NOTE: Don't conflict with existing
shortcuts (e.g. CTRL + P, N, O, C, V, etc.) You can use CTRL+SHIFT + letter
if you like.

"vdmbqb" wrote:

I have an excel 2003 spread sheet with 309 sheets. I want to create a button
on each sheet that when clicked will bring me back to sheet 1.

Thank you so much in advance.
--
bob