| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file name as specified cell when save as or save is clicked
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clicked NO to save, should have clicked YES | Excel Discussion (Misc queries) | |||
| opened excel file from email & clicked save after modify . Where i | Excel Discussion (Misc queries) | |||
| Clicked on no to save too soon | Excel Discussion (Misc queries) | |||
| SAVE OR SAVE-AS with a file name derived from a cell on the spreadsheet... | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Threaded Mode
