Catch File>Save/Save As/etc...

  • Thread starter Thread starter Sonny Maou
  • Start date Start date
S

Sonny Maou

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?
 
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.
 
Tom said:
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.
Click to expand...

Why? Why? Why?!?! Does the left hand not know what the right hand is
doing at Mickeysoft?!?! Okay, so Microslop said "Why make it easy?" All
right... let's deal with it.

Is there a library out there already done? I would hate to have to
reinvent the wheel. :)

If not, is it possible to make a customMenu class and then do something
like this:

customMenu.Replace cMWhat:="File>New", cMWith:="File>New",
cMCode="myFileNewSub"

Then I'd have to reprogram the keystrokes, right?

<pulling hair out>
 
Back
Top