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

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

Originally Posted by ppete83606

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

try this

Application.DisplayAlerts = False

--


Gary


"ppete83606" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>