Creating Hyperlinks to First Page

[razor12]

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:

<!-- BEGIN TEMPLATE: bbcode_code -->
Code:
<STYLE>.alt2 font {font: 11px monospace !important;color: #333 !important;}</STYLE>

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

</PRE><!-- END TEMPLATE: bbcode_code -->
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 new 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

 

[pboltonchina]

It looks lıke you creat a sheet every tıme and then run 3 other macros to format it how you want. Why not create a sheet how you want, complete wıth hyperlınked button, then just copy and rename that wıth the ınfo from the user input?