Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,089
Default Turn off confirmation messages via VBA

In Excel:

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Regards

Trevor


"LB" wrote in message
...
I have an Access program that I built to manipulate an Excel workbook. One
of the things I need to do is supress the confimation messages when I
delete
a worksheet via the code. I know I can supress these messages in Access,
but
I'm not sure how to accomplish that in Excel. Any suggestions?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A question about the confirmation loveflying_best[_2_] Excel Discussion (Misc queries) 1 October 8th 07 12:42 PM
How do I turn off text box for confirmation of paste command ? DaveVS Excel Discussion (Misc queries) 0 June 8th 06 04:35 PM
Getting rid of confirmation boxes DandruffKid New Users to Excel 2 March 28th 05 11:05 AM
Confirmation of file phil Excel Programming 2 January 22nd 05 02:27 AM
confirmation and close bigandyt[_2_] Excel Programming 4 July 1st 04 02:59 PM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"