Adding a Custom Keyboard Shortcut

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/keyboard-other-shortcuts-in-vba/adding-a-custom-keyboard-shortcut.html">
SHARE




To add a custom keyboard shortcut, add, save and store a VBA code line.

It is recommended that general custom keyboard shortcuts be saved in the Personal Macro Workbook. This workbook is created the first time you record and store a macro, and remains hidden when Excel is opened.

To create the Personal Macro Workbook while storing a new keyboard shortcut:

1. From the Tools menu, select Macro, and then Record New Macro.
2. In the Macro name box, insert a name for the macro (no spaces are allowed between characters).
3. In the Shortcut key box, press Shift+ V.
4. Choose Personal Macro Workbook from the Store macro in dropdown list, and click OK.
5. Record anything you like and then stop recording by pressing the Stop Recording icon.
6. Open the VBE (Visual Basic Editor) by pressing Alt+F11.
7. Double-click Module1 under VBAProject (PERSONAL.XLS).
8. In the PasteValues macro, replace the lines recorded with:
Selection.Formula = Selection.Value
This code converts a selected cell’s formula to its current value.
9. Click Save.
10. Press Alt+F4 to close and then reopen Excel.
11. To determine if PERSONAL.XLS is open, select Unhide from the Windows menu.
12. To check the keyboard shortcut, select cells containing formulas, and press Ctrl+Shift+V.

In this way we can assign keyboard shortcut in excel to open specific programs at specific time.

Please follow and like us:
7


Leave a Reply

Your email address will not be published. Required fields are marked *


7 + = thirteen

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>