No he means BeforeSave as he said.

That event has a SaveAsUI argument that informs whether SaveAs has been
invoked.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"michael.beckinsale" wrote in message
ups.com...

Nick,

Many thanks for the quick response.

I'm not sure that i understand your response. Are you saying that when
the user uses file,saveas or file,save or the save icon that is built
into the Excel menu bar that triggers the Before_Close event and
therefore by adding code l can change its behaviour?

If that is the case how does Excel know what functionality the user has
chosen. (ie SaveAs triggers the SaveAs dialog whereas Save simply saves
the workbook in its current location giving a warnign if it already
exists)

I need to ensure that whatever method the user chooses to save the file
the default name generated by the file is used.

TIA

Regards

Michael beckinsale