Is there any way, using VBA, to set the file name in the save as dialog box when the user exits the workbook or selects the save/save as via the File menu, The workbook is protected as read only and the save as dialog box automatically pops up as a result; however, I want to have a filename suggestion in the pathname. It will be saved in the current folder. There will not be a save button. I want this to be held as a variable and accessed during close or save. Oh, and I want to remove the protections but not the coding behind the scenes. I would post code but honestly I don't know where to start. All the suggestions seem to execute the code on some action (such as a save button) other than the user just closing and/or saving the document. which is not what I want. The filename will be based on a value in a cell but when this file gets saved will be up to the user, not on when the cell value changes. The filename will be based on worksheet 7, cell b3. Using Office 365.
BTW, one thing I've noticed when trying various coding suggestions thus far, when using the Workbook.BeforeSave event, the code isn't recognized unless I use ctrl s shortcut. When going through the File menu the code is not recognized.
Any and all help will be greatly appreciated.
BTW, one thing I've noticed when trying various coding suggestions thus far, when using the Workbook.BeforeSave event, the code isn't recognized unless I use ctrl s shortcut. When going through the File menu the code is not recognized.
Any and all help will be greatly appreciated.
