Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call a procedure in program
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call a procedure in program
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
procedure call | Excel Programming | |||
Call Procedure | Excel Programming | |||
Where else to look for procedure call | Excel Programming | |||
call procedure | Excel Programming | |||
procedure won't call | Excel Programming |