Thread
:
Application screenupdating not working for everything?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Application screenupdating not working for everything?
try
application.displayalerts=false
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Kai Smith" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett