Macro Playback (2003)

Topic

New Reply

I have recorded a macro which involves deleting a worksheet. When executing the macro,a warning box appears that states:

Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete. Can I stop this appearing upon execution?

Thanks
Nathan

Reply | Quote

Replies

Something like:

Application.displayalerts = false
worksheets(1).delete
Application.displayalerts = true

Steve

Reply | Quote

I knew it was something simple..

[Thanks] Steve, exactly what I wanted.

Reply | Quote