How to disable a ShortCut in EXCEL using VBA?

F

Flybean

Hi, all
I met a trouble in the following scenario:
I overrided the function of the Save Command button, so I could do some
job and then save the file. ( beforeSave event is not suit for me ). But I
noticed that it could be skiped easily by pressing Ctrl+S.
So any way to disable it, or let Ctrl+S runs my function?

Thanks a lot.

Flybean
 
C

charity

Hi, all
I met a trouble in the following scenario:
I overrided the function of the Save Command button, so I could do
some
job and then save the file. ( beforeSave event is not suit for me ).
But I noticed that it could be skiped easily by pressing Ctrl+S.
So any way to disable it, or let Ctrl+S runs my function?

Thanks a lot.

Flybean
Click to expand...
 
Top