Macro to end pop up file opening

[Anmol_happy]

Guys can anyone have macro to end the selected file from pop up.
1.File should not pop up after executing

 

[RobP]

Hi
not quite sure what you mean here, but does "Application.Screenupdating = FALSE" do anything for you if you add it before ?

(remember to set it to TRUE after you have executed the code as your last step ?)

Or maybe something like this if you wrap it around your save part ?

Application.DisplayAlerts = False
            ActiveWorkbook.Close savechanges:=True
            Application.DisplayAlerts = True

Rob