Hi guys

I have a VBA program which copies a sheet tab multiple times then
deletes the original tab (the template tab).

I've got Application.ScreenUpdating set to false, but I still get this
error when the code reaches the deletion stage:
"The selected sheet(s) will be permanently deleted.
* To delete the selected sheets, click OK.
* To cancel the deletion, click Cancel."

Is there any way I can get rid of this as it's damn annoying when trying
to automate everything and I have to click this 30+ times.

Thanks

Kai

try
application.displayalerts=false

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Kai Smith" <(E-Mail Removed)> wrote in message
news:toeCi.1$(E-Mail Removed)...
> Hi guys
>
> I have a VBA program which copies a sheet tab multiple times then deletes
> the original tab (the template tab).
>
> I've got Application.ScreenUpdating set to false, but I still get this
> error when the code reaches the deletion stage:
> "The selected sheet(s) will be permanently deleted.
> * To delete the selected sheets, click OK.
> * To cancel the deletion, click Cancel."
>
> Is there any way I can get rid of this as it's damn annoying when trying
> to automate everything and I have to click this 30+ times.
>
> Thanks
>
> Kai
>

Fantastic!

Thanks very much Don, works a charm.

Regards

"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed):

> try
> application.displayalerts=false
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Kai Smith" <(E-Mail Removed)> wrote in message
> news:toeCi.1$(E-Mail Removed)...
>
> > Hi guys
> >
> > I have a VBA program which copies a sheet tab multiple times then
> deletes
> > the original tab (the template tab).
> >
> > I've got Application.ScreenUpdating set to false, but I still get this
> > error when the code reaches the deletion stage:
> > "The selected sheet(s) will be permanently deleted.
> > * To delete the selected sheets, click OK.
> > * To cancel the deletion, click Cancel."
> >
> > Is there any way I can get rid of this as it's damn annoying when
> trying
> > to automate everything and I have to click this 30+ times.
> >
> > Thanks
> >
> > Kai
> >

glad to help
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Kai Smith" <(E-Mail Removed)> wrote in message
newsTfCi.11$(E-Mail Removed)...
> Fantastic!
>
> Thanks very much Don, works a charm.
>
> Regards
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed):
>
>> try
>> application.displayalerts=false
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "Kai Smith" <(E-Mail Removed)> wrote in message
>> news:toeCi.1$(E-Mail Removed)...
>>
>> > Hi guys
>> >
>> > I have a VBA program which copies a sheet tab multiple times then
>> deletes
>> > the original tab (the template tab).
>> >
>> > I've got Application.ScreenUpdating set to false, but I still get this
>> > error when the code reaches the deletion stage:
>> > "The selected sheet(s) will be permanently deleted.
>> > * To delete the selected sheets, click OK.
>> > * To cancel the deletion, click Cancel."
>> >
>> > Is there any way I can get rid of this as it's damn annoying when
>> trying
>> > to automate everything and I have to click this 30+ times.
>> >
>> > Thanks
>> >
>> > Kai
>> >
>