Hi Michael,
To supress the messagebox(es), you can use the DisplayAlerts property:
Application.DisplayAlerts=False
'/ delete sheet here
Application.DisplayAlerts=True
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Michael Kintner wrote:
How can I force Delete a Sheet without having a popup dialog?
I am currently doing this (ActiveWindow.SelectedSheets.Delete)
Is there anyother way?
Thank you in advance for your help...
Mike