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


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.


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

Look up Help for Application.OnKey