If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing Forms/Reports Containing Hyperlinks
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? |
#2
|
|||
|
|||
Printing Forms/Reports Containing Hyperlinks
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! -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=103640 |
Thread Tools | |
Display Modes | |
|
|