Since you are writing the code that would set the parameters, you should be
able to determine what option you set and pass that information or store it
so it can be accessed where you need it.

I doubt there is a reliable way to determine it dynamically in the
Workbook_BeforeClose event.

--
Regards,
Tom Ogilvy

"Guido Buecker" wrote in message
...
hi there,

i have an AddIn that uses the Workbook BeforeClose event.

now the wokbooks can be close using the "Workbook.Close SaveChanges=FALSE"
method.

depending on the value of the SaveChanges parameter of the Close method i
need to do
certain actions.

is there any way to get the value of the SaveChanges Parameter (or even to
know
whether Close has been called with or without parameters?)


thanks, guido