Printing Forms/Reports Containing Hyperlinks

  • Thread starter chrisexcel060409
  • Start date
C

chrisexcel060409

I have a form I created that contains hyperlinks to a dashboard. When I print
the form/report, it also prints the "Back to Dashboard" hyperlink. How do I
suppress printing of hyperlinks on forms?
 
J

jamescox

Two possibilities come to mind.

First, you could add a Print command button and have one of the actions
of that button change the font color of the hyperlink text to white - so
it would still print but not be visible - and then change it back after
the print operation was done. Not particularly difficult to do, but if
you aren't the sole user of the workbook, others might just select Print
from the menus and bypass your macro.

A more foolproof way, but probably more work, is to replace your
in-cell hyperlinks with hyperlinks associated with shapes - click the
shape and the hyperlink is followed. Shapes can be configured not to
print, which would solve the problem...

Good luck on this!
 

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

Top