MACRO & FUNCTION

[FARAZ QURESHI]

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!!!

 

[Gary''s Student]

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.

 

[Gord Dibben]

First question.........yes.

Second, see other reply.


Gord Dibben MS Excel MVP