Hello, first post.

I have a working solution to a problem my school faced.
In short we have collected the urls to all Google Classrooms. I then have extracted the pupil timetables from our MIS. Using VBA I have hyperlinked each of the pupils classes to the url for the Google Classroom. I then export them as PDF and upload them to our server so pupils can view.

When pupils view their timetable and click on one of the links it opens in that window meaning they loose their timetable unless they click the back button. I was wondering if there was a simple way to open the links in a new tab when clicking the link. I am assuming this is something that is applied in the VBA hyperlink code not elsewhere.
So far I have tried adding 
Please Login or Register  to view this content.
to the code but no success. Any help would be appreciated. Hyperlink code is below, however if you need more I can provide.

Please Login or Register  to view this content.
Jason