Thread
:
BOHICA needs more help
View Single Post
#
2
Posted to microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
BOHICA needs more help
Wrap your deletion with
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
In article ,
(BOHICA) wrote:
Okay, you Kings of Code, you Princes of Productivity....Gots me
anutter question:
I have a macro that deletes sheets in a workbook, then re-creates them
in a specified format. When the command to delete the cell is
executed, it pops up with a prompt saying these selected sheet(s) will
be permanently deleted. Is there something I can do in my code to
supress this annoying and needless (to me anyhow) pop up?
BOHICA: The other white meat
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey