Printing Forms/Reports Containing Hyperlinks

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

 

[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!