Record a macro whilst performing a task with a native menu command.

Assign a shortcut key to that macro.

From your example, recording inserting a worksheet returns this code.

Sub Macro1()
Sheets.Add
End Sub

But I would first see Help on keyboard shortcuts...........many native
commands already have shortcut keys.

Like Shift + F11 to insert a new sheet.


Gord Dibben MS Excel MVP

On Wed, 17 Dec 2008 10:44:29 -0800 (PST), Joshua
wrote:

On Dec 17, 12:40*pm, "Ron de Bruin" wrote:
Hi Joshua

Use Shift F11 to insert a new worksheet

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Joshua" wrote in ...
How do I assign an Excel menu item to a shortcut using VBA?

For example, I would like to add a procedure that inserts a worksheet
when the user presses Ctrl + Shift + I, instead of having to go to
through the native excel commands of Alt, then I, then W, or using the
mouse to navigate to Insert, then Worksheet

Thanks,

Joshua.

I would like to do this for a variety of native excel menu commands.
How do you call a native excel menu command in VBA using a keyboard
shortcut?

Thanks,

J