View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
manfred manfred is offline
external usenet poster
 
Posts: 2
Default identify 'save as' of the commandbar 'worksheet menu bar'

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