supressing system warning messages
 

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


--
ppete83606
------------------------------------------------------------------------
ppete83606's Profile: http://www.excelforum.com/member.php...o&userid=26953
View this thread: http://www.excelforum.com/showthread...hreadid=467741

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-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=467741

supressing system warning messages
 

try this

Application.DisplayAlerts = False

--


Gary


"ppete83606" wrote
in message ...

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


--
ppete83606
------------------------------------------------------------------------
ppete83606's Profile:
http://www.excelforum.com/member.php...o&userid=26953
View this thread: http://www.excelforum.com/showthread...hreadid=467741

supressing system warning messages
 

Hi Paul

Application.DisplayAlerts = False

Remember to set it back to True again at the end of your macro and to be
safe also as part of your errorhandling.

Regards
Rowan

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