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

  • Thread starter Thread starter Manfred
  • Start date Start date
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
 
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
 
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
 
Back
Top