 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Suppressing Alert messages on open
I have an automatic refresh from an imported source. I've set the profile so the refresh is done when the excel file is opened. But an alert message with 2 selections is presented. One to do the refresh and the other to skip the refresh. I want the refresh to stay automatic and wonder if there is a way to suppress the alert and default to always force a refresh from external source? Hi Bob, Include this line in the macro: Application.DisplayAlerts = False When the procedure ends, Excel automatically resets the DisplatAlerts property to True. Source: Excel VBA Programming for Dummies, John Walkenbach Regards - Dave. > Hi Bob, > Include this line in the macro: [quoted text clipped - 7 lines] > > Regards - Dave. Dave thank you for your suggestion. Unfortunately the automatic refresh is not done via a macro I can modify to add the suggested line. It is set in the data import properties by checking the option to refresh upon open. > Hi Bob, > Include this line in the macro: [quoted text clipped - 7 lines] > > Regards - Dave. On Apr 22, 10:13 am, Bob Ptacek <BobPta...@discussions.microsoft.com> wrote: > if there is a way to > suppress the alert and default to always force arefreshfrom external source? I was annoyed by the exact same thing. Here's the solution, requires a registry fix. http://support.microsoft.com/kb/248204 Thank you. While this will work on my PC, unfortunately the file is intended to be shared and is on a share drive that is opened by many. So they all would need to modify the registry. We have fixed configurations for the corporation and the only way to solve that here would be to have the PC build process apply that registry modification across the board. And sadly there is a better chance for peace in the middle east than getting our configuration build tweaked for a specific purpose. > On Apr 22, 10:13 am, Bob Ptacek <BobPta...@discussions.microsoft.com> > wrote: [quoted text clipped - 5 lines] > > http://support.microsoft.com/kb/248204 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.