View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T-容x[_77_] T-容x[_77_] is offline
external usenet poster
 
Posts: 1
Default supressing system warning messages


Hello ppete83606!
To turn warning messages on/off, you can simply set
Application.DisplayAlerts to True/False. :)

ppete83606 Wrote:
I am certain that this question has been asked and answered, so if you
can point me to the messase I will take it from there. I create a new
workbook from a button on a template, and it works great. The button
sits on a seperate worksheet, a worksheet that I delete from the
created file. When I delete, excel spits out a warning message that I
want to turn off, delete the worksheet, and turn the warning messages
back on. I know it is in one of the 3 or 4 books I have on exce, but I
can't find it because I don't know how they index it.

And by the way, my project has moved light years ahead because of
this forum. So to one and all THANKYOU, THANKYOU, THANKYOU

Paul



--
T-容x
------------------------------------------------------------------------
T-容x's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=467741