add
application.displayalert = false at the beginning of code
application.displayalert = true before end sub statement
On Wed, Apr 20, 2011 at 4:02 PM, Bhushan Sabbani wrote:
> Dear All,
>
> I have record a macro there i have delete the sheet.
> The code are as below
>
> Sheets("MNS Summary")
Dear All,
I have record a macro there i have delete the sheet.
The code are as below
Sheets("MNS Summary").Activate
Sheets("MNS Summary").Delete
but i am getting the pop up that data may exist . the option is
delete and cancel.
I have click on delete option again and again to sele
