Hello,

I would like to specify a default file name when a user selects either the
Save or Save As commands from the Menu bar in excel.

I have thought about inserting a button on the excel spreadsheet and using
VB to load the Save / SaveAs dialog box, but this would mean disabling the
normal Save / Save As menu command buttons.

The default File name would include a static name XXX followed by todays date.

Any advise would be greatly apprieciated.

Many Thanks

SM