VBA to write hyperlinks to multiple worksheets

Dear Forum Members,

I am looking for the VBA code to write hyperlinks to multiple worksheets in a Excel 2010 workbook. The hyperlink must be placed in cell H1 of each worksheet. These hyperlinks must all link back to a "dashboard" worksheet. Thanks

Something like this?

Sub AddHyperlink()
    Dim s As Worksheet
    For Each s In ActiveWorkbook.Sheets
        If s.Name <> "Dashboard" Then
            s.Range("H1").Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="Dashboard!A1", TextToDisplay:="Dashboard"
        End If
    Next s
End Sub

Actually more like this.

Sub AddHyperlink()
    Dim s As Worksheet
    
    Application.ScreenUpdating = False
    
    For Each s In ActiveWorkbook.Sheets
        If s.Name <> "Dashboard" Then
            s.Activate
            s.Range("H1").Select
            s.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="Dashboard!A1", TextToDisplay:="Dashboard"
        End If
    Next s
    
    Application.ScreenUpdating = True
End Sub

Dear foundy,

No doubt this was very easy for you, so perhaps my gratitude will seem affected, but I would be remiss if I didn't tell you that this 'little' piece of code is fantastic! Thank you very much indeed!

Dear Foundy,

I'm curious about why you disable screen updating for the loop. Does this make the makro faster?

Glad to help

Hi,

Yes it speeds up the macro, it also stops the screen flicking from sheet to sheet as it adds the hyperlinks.

Dear Winon,

Thanks for the additional spreadsheet and the advice. There is nothing I would like more than to perform the tasks that you suggested to express my gratitude but there are a few problems:

1) When I click on the login to see the answer to my question I get taken to a set of pages listing hundreds of posts and the post I am looking for is simply not there. Getting back to the post is a mission, to say the least, which was the problem I originally complained about.
2) I cannot find any "Menu" item, nor any star icon of any nature or description.

If you can show me the shortcut keys to use the forum I will certainly do so - but at the moment I am getting nowhere. Once again, thank you very much for the additional spreadsheet.