![]() |
|
#2
|
||||
|
||||
|
The simplest way, I should think, would be to go to that module and put an "Exit Sub" statement immediately after the Sub statement. That way you keep the code (in case you want to refer to it later), but it doesn't do anything.
Another way would be to remove the module entirely; you can "export" it at the same time, so you'll have the code around if you need it again. You could, of course, change your security settings so that Excel refuses to run the autorun macro without your permission. But I don't think you can make that setting specific to one workbook, so Excel would ask you about macros on every .xlsm, every time you opened one, so maybe that doesn't appeal to you. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |
#REF! error when opening a workbook that contain a refference to another workbook
|
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Select a range in one one workbook while working in other workbook
|
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |