View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Can I link to a print command from a cell?

Yes, put your code in the FollowHyperlink event of the worksheet. For
example, this will print the active sheet if the hyperlink in A1 is clicked.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$A$1" Then ActiveSheet.PrintOut
End Sub



"tcloud@lcc" wrote:

I have a spreadsheet in which I have incorporated hyperlinks to access other
pages and cells. Is it possible to program a hyperlinked cell to cause a
particular worksheet to print without having to go to the print command on
the menu bar?