saving workbook asking to rename file every time I save

F

francie

I want to save an excel document after a modification, it
will rename the file by adding 1 each
time I save the document.

Thank you!

francie
 
F

Frank Kabel

Hi
is VBA a feasible solution for you? You could use the
Workbook_BeforeSave event and increment the number.

Note: these kind of solution won't work if macros are disabled. So
please post back if this is an option for you.
 
Top