I am using Excle 2000. Is there a way to set it up to that it auto saves all excel files that are opened/created without prompting me to save it. I can set it for the file I am working on, but everytime I open a new worksheet/book it prompts me again.
thanks in advance
Eddie