View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How to suppress Excel default message

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" wrote in 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