Disabling messages while running a macro...

[Larry B]

I'm got a macro programmed that deletes a sheet in a
workbook and then saves the workbook under a different
name.

I want to run this macro as an unattended task, but every
I always get the 'are you sure you want to delete the
worksheet' and 'file exists do you want to overwrite'
message.

I always want to delete the sheet & overwrite the file.
Anyway I can disable these messages or setup the
deletesheet & saveas commands to prevent them from coming
up?

 

[Doug Glancy]

Larry,

Application.DisplayAlerts = False
'your saveas and delete code here
Application.DisplayAlerts = True

hth,

Doug

 

[Frank Kabel]

Hi
try something like:

sub foo()
'...
Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True
'..
end sub