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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Custom ShortCut Keys 1
Global Template Network and saving auto texts & macros 2
Could not Insert UserForm into VBA 0
Cut and "insert cut cells" in Excel 2007 doesn't work. 11
How do I disable an Office shortcut key? 0
Disable ALL "Send" shortcuts - Still some I don't find :-( 2
COM Addin menu shortcut are being swallowed by MS Project 4
Modify Keyboard Shortcuts? Excel 2007 4

Top