Thread: [Solved] Hyperlink Question
View Single Post
 
Old 04-11-2016, 08:11 AM
Catalinaflyer Catalinaflyer is offline Windows 7 32bit Office 2016
Novice
 
Join Date: Mar 2016
Posts: 3
Catalinaflyer is on a distinguished road
Default

Quote:
Originally Posted by Philb1 View Post
Hi
Are you a real Catalina flyer? Not many of those planes left now

Here's a couple of options for you.

Enter 99887 in Sheet 1 B5 and it will enter a Hyperlink. Click the Hyperlink & it will open the downloads folder on a W10 computer & delete the hyperlink so it's not still there for anyone to click.

Enter 99887 in Sheet 2 B5 for the downloads folder to open on a W10 computer & delete 99887 from B5.

Right click the sheet tabs & select view code to change the FolderPath, ReqTargetCellVal and TargetCell variables to suit your needs.

Have fun
On your first question, yes I used to fly a PBY-5A Catalina retrofitted as a water bomber for fire fighting. However the username came from flying helicopter tours between Long Beach and Catalina Island about 27 years ago.

I'll try out the link on my W10 machine at home tonight, I was away all weekend and just landed here about an hour ago. My office system is all W7 due to security requirements with my server (some really technical stuff I don't understand from the IT company that maintains my network and servers).
Reply With Quote