| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When open an old xls, an new macro is in a new module.
I assume you mean record a macro. I don't think you can change that
behavior, but you can always copy the recored code to module1 and delete the new module. -- Regards, Tom Ogilvy "Peter" wrote in message ... Whenever I open an old xls file, then I assing an new macro, the Excel automatically assign the code in a new module. Is there is any way you can configure it to assign the new macro in Module1? Please advise. Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which macro module | Excel Discussion (Misc queries) | |||
| When i open excel, i i get: Compile error in hidden Module, HELP! | Excel Discussion (Misc queries) | |||
| macro to standard module | Excel Discussion (Misc queries) | |||
| Run module ON OPEN event?? | Excel Programming | |||
| Open a XLS from a Module | Excel Programming | |||
Linear Mode
