button to go to specific tab
Group all the sheets together by right-clicking on a sheet tab and
clicking Group All Sheets. Then in H1, say, you can enter this
formula:
=HYPERLINK("#Sheet1!A1","First page")
Then ungroup the sheets by right-clicking on a sheet tab and clicking
Ungroup.
This will put a clickable hyperlink in cell H1 on every sheet, showing
"First page" - just click on it to get there.
Hope this helps.
Pete
On Dec 7, 5:16*pm, 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
|