Can someone help me? I have a document I have created in MSExcel. It is
being used by multiple users. I would like them to be able to have them
access the form, fill in the information and then when they go to save it
have the default save as filename be a specified cell value from the
spreadsheet. I have written code that does the filename as specified value
but I can only get it to run when I Run Code from VBA or when I choose
MacroRun. Or I can get it to loop consistently on file open. I want it to
run when the user clicks save or saveas. Thanks for your help.