Can I link to a print command from a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
trying to create a link to a link in Excel (2007) 3
Find the row for a Hyperlink 2
Help with hyperlinks 2
Hyperlink with Code 6
Userform to Select what worksheets to print 1
command button help 3
Excel Macro to hyperlink an archived worksheet to an index page 0

Back
Top