Avoid Window Message while deleting a sheet

[maperalia]

I have problem deleting a sheet from a workbook.

Basically, my file (test.xls) is in read only (selected in attributes) . I
want to deleted a sheet "A" as soon the macro is done. However, every time I
do it I got the following window message:
"DATA MAY EXIST IN THE SHEET(S) SELECTED FOR DELECTION. TO PERMANENTLY
DELETE THE DATA, PRESS DELETE"
How can I add an statement in my program to avoid this windows message. Well
as a I mentioned my file is in read only and I want to delete it without
getting any window message.

Thanks in advance.
Maperalia

 

[Corey]

Try,

Application.DisplayAlerts=False


Corey....

I have problem deleting a sheet from a workbook.

Basically, my file (test.xls) is in read only (selected in attributes) . I
want to deleted a sheet "A" as soon the macro is done. However, every time I
do it I got the following window message:
"DATA MAY EXIST IN THE SHEET(S) SELECTED FOR DELECTION. TO PERMANENTLY
DELETE THE DATA, PRESS DELETE"
How can I add an statement in my program to avoid this windows message. Well
as a I mentioned my file is in read only and I want to delete it without
getting any window message.

Thanks in advance.
Maperalia

 

[Dave Peterson]

Application.displayalerts = false
'code to delete the sheets
application.displayalerts = true

Readonly won't be a bother until/unless you try saving it using the same name.

 

[maperalia]

Corey;
Thanks very much. It is just want I need.

Maperalia

 

[maperalia]

Dave;
Thanks very much. It is just want I need.

Maperalia