Tag Macro to an Image
Sub Run_Macro_On_ImageClick()
Dim sht As Worksheet
Dim shp As Shape
' Use OnAction Property to set the macro that needs to be run when the image is clicked
Set sht = ActiveSheet
Set shp = sht.Shapes(1)
shp.OnAction = "Macro1"
End Sub
Showing posts with label VBA Tag Macro to an Image. Show all posts
Showing posts with label VBA Tag Macro to an Image. Show all posts
Friday, May 04, 2007
Subscribe to:
Posts (Atom)
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
