MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shortcut key Modifications

Posted by Ben on August 14, 2000 2:25 AM

Is it possible to modify the macro kicked off by a shortcut key. In particular, I want Ctrl+P to start my own Print Macro rather than the standard print function.



Posted by David on August 14, 0100 3:33 AM

Alt f8
select your macro and click options
under short cut key type p.

This works only when the workbook with the macro is open.

If it is a generic macro put it in the personal workbook so it will always work on your computer.