------ Register to get rid of these "In Post" ads! ------


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?

------ Register to get rid of these "In Post" ads! ------


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!