Hyperlink calls macro passing argument

[Jeff]

Can you click on a hyperlink containing an argument, that calls a macro with
the argument.

I need to pass a string or Argument to the Macro with a Hyperlink

example
in spreadsheet you have
A
1 Hyperlink
2 Supplier

would run Macro
ABC("A2")
or
ABC("Supplier")

 

[Jim Cone]

You have an answer in your original post (23 minutes earlier) .
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Jeff" <[email protected]>
wrote in message
Can you click on a hyperlink containing an argument, that calls a macro with
the argument.

I need to pass a string or Argument to the Macro with a Hyperlink
example
in spreadsheet you have
A
1 Hyperlink
2 Supplier

would run Macro
ABC("A2")
or
ABC("Supplier")

 

[Jeff]

Thank You for the Help

I've had trouble being able to post a message at times.
Sorry for duplicates

Please Help... this is basic stuff but can't seem to figure it out.
How do you hide a command button in vba???
these don't work...
Worksheets("Service Information").Range("B13").Hide = False
Worksheets("Service Information").Range(Cells("B13")).Hide = False
Worksheets("Service Information").Range("B13:B13").Visible = False

 

[Jeff]

I figured it out.


Dim SH As Worksheet
Set SH = ThisWorkbook.Sheets("Sheet1")
If Range("A1").Value2 = "" Then
With SH.OLEObjects("CommandButton1")
.Visible = False
.Enabled = False
End With
Else
With SH.OLEObjects("CommandButton1")
.Visible = True
.Enabled = True
End With