Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Suppress MSOffice warning through VBA

Posted on 2008-11-06
2
Medium Priority
?
474 Views
Last Modified: 2013-11-27
I have a piece of code that runs the show desktop button in the quick launch bar.  The problem is that it is a Windows Explorer Command (.scf extension) .

When I run the code I get a warning that says:

"opening program can contain viruses or be harmful to your computer be certain that this file is from a trustworthy source"
"Would you like to open this file?"

Is there a way to suppress this warning?  It says its coming from MSOffice so I don't think it is exclusive to Access I think it may be apart of VBA or the Office Family

Here is the code:



Here is the code in VBA
 
Application.FollowHyperlink "C:\test.scf"
 
This is the .scf file 
[Shell]
Command=2
[Taskbar]
Command=ToggleDesktop

Open in new window

0
Comment
Question by:ClaudeWalker
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 22898783
see this link
How to disable hyperlink warning messages in Office 2003
http://support.microsoft.com/kb/829072
0
 

Author Comment

by:ClaudeWalker
ID: 22899534
Thats what I was looking for.  I am not sure if that will be a viable solution because then users could click other hyperlinks outside of Access and not get a much needed (in their cases) warning.

but this did answer my question,

Thanks,
JOe K.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
I came across an unsolved Outlook issue and here is my solution.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question