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

Try,

Application.DisplayAlerts=False


Corey....

"maperalia" <(E-Mail Removed)> wrote in message
news:0518C159-951D-4E0D-9C9C-(E-Mail Removed)...
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

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 wrote:
>
> 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

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

Maperalia

"Corey" wrote:

> Try,
>
> Application.DisplayAlerts=False
>
>
> Corey....
>
> "maperalia" <(E-Mail Removed)> wrote in message
> news:0518C159-951D-4E0D-9C9C-(E-Mail Removed)...
> 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;
Thanks very much. It is just want I need.

Maperalia

"Dave Peterson" wrote:

> 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 wrote:
> >
> > 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
>