Delete a sheet
 

Hi
I want to be able to delete a sheet - how can I stop the system confirmation
message appearing.

In access I use docmd.setwarnings = false - is there something similar for
Excel

Thanks

Delete a sheet
 

Try something like

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


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




"Newbie" wrote in message
...
Hi
I want to be able to delete a sheet - how can I stop the system
confirmation
message appearing.

In access I use docmd.setwarnings = false - is there something
similar for
Excel

Thanks

Delete a sheet
 

thanks - works a treat!

"Chip Pearson" wrote in message
...
Try something like

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


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




"Newbie" wrote in message
...
Hi
I want to be able to delete a sheet - how can I stop the system
confirmation
message appearing.

In access I use docmd.setwarnings = false - is there something
similar for
Excel

Thanks

Delete a sheet
 

Don't know if it would be of interest since you are already
working with a macro of your own.

I have a macro that I invoke from the toolbar to delete
the active sheet under certain conditions.

If there is code associated with the sheet -- don't delete
and exit the macro.

If the sheetname begins with "Sheet" then delete without warning.
Otherwise, let the standard dialog come up with warning.

Keeps me out of trouble when I go through all the worksheets
quickly. I use toolbar buttons to do that but you can go through
the worksheets with Ctrl+PageUp or Ctrl+PageDown.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chip Pearson" wrote in message
Application.DisplayAlerts = False
' delete the sheet
Application.DisplayAlerts = True

"Newbie" wrote in ...
I want to be able to delete a sheet - how can I stop the system
confirmation message [from] appearing.