| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Surpressing a Message
I have several hyperlinks which I'm activating using VBA. Is there any
way to surpress the following message (Application.diDisplayAlerts = False doesn't seem to work): ======================== MICROSOFT OFFICE Opening blablah.sql Some files can contain viruses or otherwise be harmful to your computer It is important to be certain that this file is from a trustworthy source. Would you like to open this file? OK Cancel ======================== Any help much appreciated Jason. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Surpressing a Message
I'm only asking this because of the way you spelled the command.
Did you spell the command right? Application.DisplayAlerts = False -- I am running on Excel 2003, unless otherwise stated. Please rate posts so we know when we have answered your questions. Thanks. "WhytheQ" wrote: I have several hyperlinks which I'm activating using VBA. Is there any way to surpress the following message (Application.diDisplayAlerts = False doesn't seem to work): ======================== MICROSOFT OFFICE Opening blablah.sql Some files can contain viruses or otherwise be harmful to your computer It is important to be certain that this file is from a trustworthy source. Would you like to open this file? OK Cancel ======================== Any help much appreciated Jason. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Surpressing a Message
Generally speaking warnings about viruses and security issues can not be over
ridden. If you could then there would be no point to them as visues and such would just turn them off... -- HTH... Jim Thomlinson "WhytheQ" wrote: I have several hyperlinks which I'm activating using VBA. Is there any way to surpress the following message (Application.diDisplayAlerts = False doesn't seem to work): ======================== MICROSOFT OFFICE Opening blablah.sql Some files can contain viruses or otherwise be harmful to your computer It is important to be certain that this file is from a trustworthy source. Would you like to open this file? OK Cancel ======================== Any help much appreciated Jason. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Surpressing a Message
Thanks Jim - had a feeling that might be the answer.
J On 22 Sep, 18:52, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: Generally speaking warnings about viruses and security issues can not be over ridden. If you could then there would be no point to them as visues and such would just turn them off... -- HTH... Jim Thomlinson "WhytheQ" wrote: I have several hyperlinks which I'm activating using VBA. Is there any way to surpress the following message (Application.diDisplayAlerts = False doesn't seem to work): ======================== MICROSOFT OFFICE Opening blablah.sql Some files can contain viruses or otherwise be harmful to your computer It is important to be certain that this file is from a trustworthy source. Would you like to open this file? OK Cancel ======================== Any help much appreciated Jason.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Surpressing plot of blank cells | Charts and Charting in Excel | |||
| Surpressing rows and columns with zero values in a pivot table | Excel Discussion (Misc queries) | |||
| Visually Surpressing A Macro | New Users to Excel | |||
| surpressing listbox changes | Excel Programming | |||
| Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming | |||
Linear Mode
