Deleting Worksheet using VB

  Desert Andy 14:51 27 Nov 2004
Locked

I am trying to delete a sheet in Excel using VB, however, it comes up with a message confirming if I want to delete the sheet since data could be lost. Any way of getting around this.
Thanks - Andy

  VoG II 14:56 27 Nov 2004

Application.DisplayAlerts = False

(delete the sheet)

Application.DisplayAlerts = True

  pc moron 14:57 27 Nov 2004

Use,

Application.DisplayAlerts=False

or

Application.DisplayAlerts=True

to enable/disable the messages.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?