The SaveAsUI parameter of the WorkbookBeforeSave event passes True if the
Save As dialog will be displayed. See Help.

--
Jim Rech
Excel MVP
"Manfred" wrote in message
...
| Hey,
|
| in case of saving a worksheet the user should get a
| message "Do you want to change the original
| spreadsheet ?". But this advice should not raise when the
| user wants to 'save as'.
|
| Using the beforeSave-Event will capture both of the above
| actions. But how to distinguish the actions 'save'
| and 'save as' ?
|
| Thanks for your hints
| Manfred