Macro to Delete a Worksheet
Posted by Denis Mc on January 09, 2002 7:14 AM
Hi
When i create a Macro to delete a worksheet i always get the confirm dialog box which stops the macro completing properly. How can i edit the macro properties so this runs through automatically.
Many thanks
Denis
Posted by Juan Pablo G. on January 09, 2002 7:27 AM
Just use:
Application.DisplayAlerts = False
before you delete the sheet, then, after, restore it to TRUE.
Juan Pablo G.
Posted by DenisMc on January 09, 2002 7:36 AM
LOVELY! thanks
