The first thing to try is to set DisplayAlerts to False. This prevents
most (but not all) dialogs from being displayed and the code continues
to execute as if the user clicked the default button on the dialog. In
Excel/VBA, this would be
Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
[URL="http://www.cpearson.com"]www.cpearson.com[/URL]
(email on web site)
On Fri, 24 Jul 2009 12:05:55 -0700 (PDT), Maury Markowitz
wrote:
>I have an Access app that uses Excel to format up and send short e-
>mails. This process is fraught with peril, because if Excel puts up a
>dialog box you're pretty much rebooting. I've managed to find most of
>the problem cases that would do this and eliminate them over time.
>
>However, on ONE USERS machine I'm getting an "error" I have never seen
>before. On MailEnvelope.Item.Send a dialog appears saying something
>like (sorry, no screen shot) "This document contains hidden columns
>that the recipient may be able to view. Send anyway?" There are no
>hidden columns. In fact, the line right above the .Send is an autofit
>the ensures this is the case.
>
>Does anyone have any idea what might be triggering this?
>
>Any suggestions? Perhaps turning off dialogs in excel? Is there a
>downside to that approach? >> Stay informed about: Odd error dialog 
FAQ
Search
Profile
Private Messages
Log in
