dont confirm save with yes/no/cancell
 

i got a macro to save as a workbook. it needs to overright an excisting
one. how do i get it not to ask/say i am about to overight?

dont confirm save with yes/no/cancell
 

Try this:

Before your save code:
Application.DisplayAlerts = False

After your save code:
Application.DisplayAlerts = True

HTH,
Paul

"pswanie" wrote in message
...
i got a macro to save as a workbook. it needs to overright an excisting
one. how do i get it not to ask/say i am about to overight?

dont confirm save with yes/no/cancell
 

Application.DisplayAlerts = False
Activeworkbook.SaveAs . . .
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"pswanie" wrote:

i got a macro to save as a workbook. it needs to overright an excisting
one. how do i get it not to ask/say i am about to overight?