svendiamond
Well-known Member
- Joined
- Jun 13, 2014
- Messages
- 1,504
- Office Version
- 365
- Platform
- Windows
I have a macro button that automatically runs three reports (excel spreadsheets) from my company's intraweb database application. The only issue with this is the hyperlink warning message that automatically pops up. It basically warns that some files from the internet may be harmful and make sure it's a trustworthy source. Then says "Would you like to open this file?" and you have to click "OK" or "Cancel". The user must click "OK" for each of the three reports. I want to get rid of this message. I have Googled this problem for weeks now and the only 2 possible solutions I've found are:
1. Globally disable hyperlink warning by editing the registry (one of the first results on Google... from the Microsoft website) -- This is easy and would work just fine, but I don't have permission to edit the registry on my company's computers.
Or option 2 which apparently works but I don't know where to put the code!
2. Something about ShellExecute API which I know nothing about. In this thread: Bypass hyperlink prompt in VBA? I found this link: API: Start an app with ShellExecute to some code which uses ShellExecute API which apparently worked and disabled the hyperlink warning message. But, I have no idea where to put this code. Do I just click on the tab for the sheet in my workbook, and click "view source" and put the code there? Also, do I need the entire thing? Sorry but I really have no idea what I'm looking at with this particular code, I am only a novice with VBA.
If anyone can help I would really appreciate it and my company would love me! Nobody wants to sit and wait to click "OK" every minute while the reports run!
1. Globally disable hyperlink warning by editing the registry (one of the first results on Google... from the Microsoft website) -- This is easy and would work just fine, but I don't have permission to edit the registry on my company's computers.
Or option 2 which apparently works but I don't know where to put the code!
2. Something about ShellExecute API which I know nothing about. In this thread: Bypass hyperlink prompt in VBA? I found this link: API: Start an app with ShellExecute to some code which uses ShellExecute API which apparently worked and disabled the hyperlink warning message. But, I have no idea where to put this code. Do I just click on the tab for the sheet in my workbook, and click "view source" and put the code there? Also, do I need the entire thing? Sorry but I really have no idea what I'm looking at with this particular code, I am only a novice with VBA.
If anyone can help I would really appreciate it and my company would love me! Nobody wants to sit and wait to click "OK" every minute while the reports run!
