Thread: [Solved] Hyperlink Question
View Single Post
 
Old 04-08-2016, 09:43 PM
Philb1 Philb1 is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2016
Location: Auckland
Posts: 43
Philb1 is on a distinguished road
Default

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
Attached Files
File Type: xlsm OpenFolderVBA.xlsm (22.1 KB, 15 views)
Reply With Quote