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

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

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

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