View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diane Diane is offline
external usenet poster
 
Posts: 96
Default Macro to be used in any cell

How do I make a macro available in any cell of a worksheet.
I created it in a cell, but I want to be able to use it in any cell. Thanks.

Range("L1058").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"..\..\..\Customer Filing\"
Range("L1058").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("C1").Select
Application.CommandBars("Stop Recording").Visible = True
End Sub