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?

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

"Vijay Kotian" <(E-Mail Removed)> wrote in message
news:CFC987F3-9DDC-4431-9DDC-(E-Mail Removed)...
> 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?
>