Originally Posted by
bruno2580
Hi Ravisca2003,
I have only selected to col. N on the print function as I don't require to print the hyperlinks of the manuals.
the original question I am talking about is in userform 2 when I search my equipment and for every peace of equipment it shows up the hyperlink manual in label 13.
However if I don't have a hyperlink saved in col N for that item and I click on the word manual in the userform it comes up with a error.
This is why I am asking is there a way to stop the word showing up if there isn't a hyperlink displayed in the Col N
Hi Bruno,
Sorry. I got it now what you are saying . This is done . Please refer attached sheet. I made a small change by introducing if condition in the code below
Please add reputation if this help
Bookmarks