dont confirm save with yes/no/cancell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try this:

Before your save code:
Application.DisplayAlerts = False

After your save code:
Application.DisplayAlerts = True

HTH,
Paul
 
Application.DisplayAlerts = False
Activeworkbook.SaveAs . . .
Application.DisplayAlerts = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a folder 3
if workbooks exists delete 4
Addin not allowing thisworkbook.save in before save event 3
Copying modified files only 10
Function created in VBA not listed in worksheet existing functions.Pleae Help 3
Auto save question 2
Ok or Cancel code 3
need code to open new excel workbook 2

Back
Top