View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default button to go to specific tab

On Sun, 7 Dec 2008 09:16:03 -0800, 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.


Create the button and connect the following code to it:

Sub Button1_Click()
Worksheets("Sheet1").Activate
End Sub

Hope this helps / Lars-Åke