Roger,

That is just a comment to let you know that the macro is using a shortcut,
it doesn't actually do anything about the shortcut. Delete the comments and
the shortcut still works.

Shortcut key details are held in Excel memory.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger PB" wrote in message
...
When using Excel's macro recorder to define a macro, one has the option of
giving it
a keyboard shortcut.
This appears in the finished macro as a comment.
But comments are not executed, I thought.

So what and where is the code giving the subroutine a shortcut, and how
would one enter it on the code page directly rather than by using the
macro recorder?

Roger PB