identify 'save as' of the commandbar 'worksheet menu bar'

M

Manfred

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
 
G

GJones

Hi Manfred;

Excell normally detects if changes have been made but in
some cases especailly if changes have been made using VBA
code it will not. You can control wether the user gets
prompted by using this line in you code.


ActiveWorkbook.Saved = False


If you set it to false they will get prompted no matter
what and if you set it to true then they will not.

Hope it helps,

Greg
 
J

Jim Rech

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

--
Jim Rech
Excel MVP
| 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
 
Top