Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USING AN .xla FILE TO STORE MACROS
Thanks very much for your responses. I am now using only an .xlA file on the shared network drive. It i never installed as an add-in (is there any disadvantage to doing this Bob?). When I execute a macro (via clicking on a macro icon in the Standar Toolbar) and then want to edit the code, I key 'Alt+{F11}' and selec the Module of interest and 'View Code'. I can then make any desire changes and click-on the 'Save' icon to preserve those changes in th .xlA file. I would like to 'Step Into' a macro in the .xlA file. After openin the Editor, I click-on the 'Continue' icon and the macro library windo pops up; I select the macro of interest and click-on the 'Step Into button. I then get the yellow arrow indicating 'Step Into' mode however, I cannot get the macro to execute line-by-line by using th {F9} key (although I can get the macro to run continuously between tw code lines by clicking in the margin and inserting a brown circle nex to each of the two code lines of interest). I would like to be able t 'Step' line-by-line between two brown circles. Thanks for your help, Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=27384 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
USING AN .xla FILE TO STORE MACROS
Now installing it as an add-in won't give you any particular problems, but
it does mean that rather than Excel loading it automatically on startup, you have to open it (un less it is in the XLStart directory), but that might not be such a big deal to you. Stepping through is {F8} not {F9} Does that solve it, as it should be no different for xla's. -- HTH RP (remove nothere from the email address if mailing direct) "Chuckles123" wrote in message ... Thanks very much for your responses. I am now using only an .xlA file on the shared network drive. It is never installed as an add-in (is there any disadvantage to doing this, Bob?). When I execute a macro (via clicking on a macro icon in the Standard Toolbar) and then want to edit the code, I key 'Alt+{F11}' and select the Module of interest and 'View Code'. I can then make any desired changes and click-on the 'Save' icon to preserve those changes in the xlA file. I would like to 'Step Into' a macro in the .xlA file. After opening the Editor, I click-on the 'Continue' icon and the macro library window pops up; I select the macro of interest and click-on the 'Step Into' button. I then get the yellow arrow indicating 'Step Into' mode; however, I cannot get the macro to execute line-by-line by using the {F9} key (although I can get the macro to run continuously between two code lines by clicking in the margin and inserting a brown circle next to each of the two code lines of interest). I would like to be able to 'Step' line-by-line between two brown circles. Thanks for your help, Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=273840 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where to store macros? | Excel Discussion (Misc queries) | |||
USING AN .xla FILE TO STORE MACROS | Excel Programming | |||
Macros to store the formatiing in template | Excel Programming | |||
How to store organization wide macros? | Excel Programming | |||
Where to store standard macros | Excel Programming |