Hide saving bar during VBA

[ianto2842]

Hi, I have a script that I've built that creates copies of itself and saves them in various areas. During the script I have used Application.ScreenUpdating to hide all the flickering but because it saves about 5 times, the save bar pops up and disappears several times. I wondered if there was a way to stop that so it just runs without anything appearing? Just wanted it to look more professional haha. I want to stress that it's not a save option where the user needs to click anything, its just the saving progress bar.

Thanks!

 

[dave3009]

Hi

If you are asking a question about your code it would be useful to post it so that others can see what method you are using, even if (in this instance) it's just the lines where you save!!

I find that this method doesn't usually create a save popup:

ThisWorkbook.SaveCopyAs "full_save_path_location"

Switch out full_save_path_location for your full save location and include the file extension, e.g. C:\Users\ianto2842\Documents\MyDoc.xlsm