How to call a procedure in program

[Guest]

I got two queries

1. I would like to call a procedure which is already there in my harddisk
(macros written earlier. While calling a procedure written earlier, if
possible to call procedure not from begining somewhere from middle) if
possible?

2. I got more than 50 macros written and every time it asks for short key.
All short keys are already used in my earlier macros, Presently i remove the
file from Excel - Macros directory to add new macro, if there any other best
alternative?

 

[NickHK]

Vijay,
1 - Not sure what you mean, as macros (VBA code) is stored in workbooks. The
workbook has to open before you can run the code.
Then you can Call/Run the code routine (sub or function), but this obviously
starts from the beginning of the routine and continues to the end.

2 - You do not have to set a short-cut key. Only use it for the common code
that you run frequently. If the workbook is not open, its macros short-cut
keys will do nothing.

NickHK