View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Catch FileSave/Save As/etc...

There isn't one. You can remove the menu item and replace it with your own,
us onkeys to remap and shortcut keys and so forth.

--
Regards,
Tom Ogilvy



"Sonny Maou" wrote in message
...
In Word VBA, I can write a

sub FileSave()

or

sub FileSaveAs()

to intercept the file menu "Save" and "Save As..." items and do some
processing prior to the save. What is the analogous method in Excel VBA?