Do not show "Saving" bar

Question

So at the moment I have a macro that creates a series of pdf files and saves them in a folder, and it works fine but when I do "ScreenUpdating off" then every time a file is being saved a Bar showing that the file is being saved is opened and it does not close on its own.

I already tried doing

 Application.DisplayAlerts = False

but it does not solve the issue, the bar still appears for each file and it wont close

Note:

I just tried

Application.DisplayStatusBar = False

but its not working either

score 0 · Answer 1 · answered May 14 '20 at 14:09

0

Maybe try to add this :

With Application.DisplayAlerts = False               
     alerts.AlertBeforeOverwriting = False 
     alerts.ScreenUpdating = False

I bet that the alert you have is an overwriting alert so it might fix you issue.

answered May 14 '20 at 14:09

TourEiffel

4,034
2
16
45

No, this did not work, I still get 3 saving bars for each file and they wont close, this only started happening when I turn screen updating off, before that the bars would close without a problem – sam0406 May 14 '20 at 14:15
@sam0406 can you add a screenshot of the message pls – TourEiffel May 14 '20 at 14:16
Did you try [this](https://stackoverflow.com/a/48230950/11167163) ? – TourEiffel May 14 '20 at 14:17
ive added a picture now, basically it shows that, the part that is blurred is the path of the folder where its being saved but then the screen never closes on its own – sam0406 May 14 '20 at 14:28
DoCmd.setwarnings false gives me an error of "object required" – sam0406 May 14 '20 at 14:32
@sam0406 try to add Access Reference – TourEiffel May 14 '20 at 14:36
what do you mean by this? – sam0406 May 14 '20 at 14:38
[Go there](https://www.datanumen.com/blogs/add-object-library-reference-vba/) – TourEiffel May 14 '20 at 14:39

Do not show "Saving" bar

1 Answers1