Thread: Hyperlinks to homepage/summary page

Hi Guys

I am busy trying to write a little excel program where I have a summary page as the first page, I am able to create new sheets on the click of a button, a userform pops up and I enter a name for that new sheet.

Now what I would like to do, is create a button which can take me back to the SUmmary page from my newly created sheet:

this is how my code looks so far:

Private Sub CommandButton1_Click()
'
' OpenNewSheet Macro
' Opens new sheet to show detailed audit work.
'

'
    Sheets.Add(After:=Sheets(Sheets.Count)).Name = TextBox1
    Worksheet.Hide
    
    TextBox1 = ""

    InsertPictureInRange "C:\Data\Office\My Pictures\pwclogo.gif", Range("A2:C5")
    
    Cells.Borders.LineStyle = xlLineStyleNone
    Cells.Interior.Pattern = xlPatternSolid
    Cells.Interior.PatternColor = RGB(255, 255, 255)
    
    Underline
    PreparedSection
    Save
    
End Sub

This is my first attempt at using VBA.

I am using a lot of google searching and trial and error to get what i need.


So in the end I want to have my summary page with hyperlinks to each newly created worksheet, then i want a hyperlink/button on each worksheet to link back to the summary page.

i want the summary page hyperlink to be created on the command click above. Is it possible to insert an image to and create a hyperlink on the image back to the summary page? what would be the easiest thing to do?

I have tried all sorts to try and get a hyperlink back to the summary page, but none have been succesful. ( I have used activesheet.hyperlinks function)

Any help would be greatly appreciated, spent a couple of hours trying to ge tthis seemingly simple thing sorted