How to suppress Excel default message

Hello -

I have a button that deletes a sheet. Prior to the sheet being deleted,
Excel has a message box that pops up asking if you really want to delete it.
I need to suppress that message. Is there a way you can keep default
messages from displaying?

Any help will be greatly appreciated!
--
Sandy

Sandy,

Try code like

Application.DisplayAlerts = False
' delete the sheet
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sandy" <[email protected]> wrote in message
news:[email protected]...
> Hello -
>
> I have a button that deletes a sheet. Prior to the sheet being
> deleted,
> Excel has a message box that pops up asking if you really want
> to delete it.
> I need to suppress that message. Is there a way you can keep
> default
> messages from displaying?
>
> Any help will be greatly appreciated!
> --
> Sandy

Thanks, Chip!
--
Sandy


"Chip Pearson" wrote:

> Sandy,
>
> Try code like
>
> Application.DisplayAlerts = False
> ' delete the sheet
> Application.DisplayAlerts = True
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Sandy" <[email protected]> wrote in message
> news:[email protected]...
> > Hello -
> >
> > I have a button that deletes a sheet. Prior to the sheet being
> > deleted,
> > Excel has a message box that pops up asking if you really want
> > to delete it.
> > I need to suppress that message. Is there a way you can keep
> > default
> > messages from displaying?
> >
> > Any help will be greatly appreciated!
> > --
> > Sandy
>
>
>