Greetings,
Is there VBA code to disable/not display the "Saving As" dialog box that shows when the file is saving?
I'm playing around with code for when a variety of files are opened, they will open an excel file which will keep a count of number of times the files have been opened by increment a specified cell +1, save the count file then close it.
Screen updating is off while running, but the saving dialog (not the save as) is showing (slow work network)
Cheers
Is there VBA code to disable/not display the "Saving As" dialog box that shows when the file is saving?
I'm playing around with code for when a variety of files are opened, they will open an excel file which will keep a count of number of times the files have been opened by increment a specified cell +1, save the count file then close it.
Screen updating is off while running, but the saving dialog (not the save as) is showing (slow work network)
Cheers