Hello,
Lets say I have a folder (which we'll call Forms), which contains a number of Excel files. The names of these files will change each day. All files in the folder need to be printed at the end of each day. Problem is - these files contain volatile formulas or linked pictures (not sure which), this is causing the save prompt to occur for each file as it prints.
I would like my code to run from a workbook that will hold only this code (attached to buttons), the workbook could then be pasted into the 'Forms' folder each day, opened, code is then run which will disbale the save prompt for all the files in the 'Forms' folder (or disable the save prompt for the Excel application would be fine too). Then I guess a second piece of code could turn the save promt back on.
I've tried using the Application.DisplayAlerts function, but it doesn't seem to do the trick.
Any help would be greatly appreciated,
Gregg
Bookmarks