Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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


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

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


Look up Help for Application.OnKey

Ivan


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.