i am trying to write a macro to delete the hyperlink in G1; i want all other
hyperlinks in column G to remain functional. [i daily copy & paste info into
this column but don't want the title's hyperlink to be used.] when i use the
following code, it works the first time. but while testing (i'm new at vba),
when i copy a hyperlink from G2 or G10 etc., up to G1 & run my macro again,
it usually removes the hyperlink from all except the last one in the column
(i.e., it removes G1:G9 hyperlinks & leaves G10's). why is this happening?

Sub Hyperlink_Remove(
Workbooks("Fiduciaries.xls").Worksheets("Sheet4"). Range("G1").Hyperlinks.Delete
End Sub

thank you for any suggestions.
elizabeth