Lets say that you have already entered a macro manually and want to assign a
shortcut to it. From the Excel window:

ALT-F8
Select the macro
Options...
enter the shortcut.

--
Gary''s Student - gsnu200768


"FARAZ QURESHI" wrote:

Can a Macro as well as a Userdefined Function exist in a single module.

Upon entering a Macro code manually how can you access or assign a short key
to it?

Thanx!!!