Not printing hyperlinks

  • Thread starter Thread starter mark1
  • Start date Start date
M

mark1

Is there a way to print the page without the hyperlinks
showing up on the printout? I know you can with objects,
but don't know about hyperlinks.

Thanks!!
 
Hi mark1

With a macro it is possible

Sub test2()
Dim hyp As Hyperlink
For Each hyp In ActiveSheet.UsedRange.Hyperlinks
hyp.Range.Font.ColorIndex = 2
Next hyp

ActiveSheet.PrintOut

For Each hyp In ActiveSheet.UsedRange.Hyperlinks
hyp.Range.Font.ColorIndex = 5
Next hyp
End Sub
 
You must log in or register to reply here.

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

Open specific hyperlink (accept) automatically in email with outlook 0
Will not auto open .jpg 1
make Hyperlink jump on the top row 2
Print hyperlink when saving to PDF. 1
Activating hyperlinks 3
Change hyperlink name to url 1
Word hyperlink not showing once merged 0
Hyperlinks changed by Excel again! 5

Back
Top