MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to trap the "Ctrl+S" shortcut in Macro?


Posted by Anjali on November 29, 2000 12:56 PM

Hi,

I need to trap the "Ctrl + S" shortcut in my macro and
make my own procedure work when the user selects the
"Ctrl+S" option.

I don't want the default dialog box that opens when we
select "Ctrl+s".

Please help me.

TIA,
Anjali

Posted by Iva on November 30, 2000 3:09 AM


Look up Help for Application.OnKey

Ivan