View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Saveas Dialog Box

You can use the BeforeSave event. If you mean differentiate, check the
SAVEUI argument to that event.

--
Regards,
Tom Ogilvy

"VJ" wrote in message
...
Is there any way, I can find out whether user has clicked "Save" button or
"Saveas" button in the file menu through coding.

Help would be appreciated.

Thanks