View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vdmbqb vdmbqb is offline
external usenet poster
 
Posts: 36
Default button to go to specific tab

I found out how to create a button and now I have the code to assign-but I
can not figure out how to assign the code.
--
bob


"Lars-Åke Aspelin" wrote:

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