View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
maperalia maperalia is offline
external usenet poster
 
Posts: 258
Default Avoid Window Message while deleting a sheet

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