Delete Sheets
hi Sharon
try
Application.DisplayAlerts = False
' delete sheet here
Application.DisplayAlerts = True
HTH
Frank
SS wrote:
How can I when deleting a sheet, use code to keep from
having to answer "yes" to the excel popup "The selected
sheets will be permanently deleted. ...."
Thanks
Sharon
|