| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Macros to make one Macro.
The macros only vary by the name of the linked file. Assuming they all have
just one linked file you can break it by position rather than by name: ActiveWorkbook.BreakLink _ ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLi nks)(1), _ xlLinkTypeExcelLinks So you only need one macro. Use this to block the prompt: Application.DisplayAlerts = False ActiveWorkbook.ExclusiveAccess -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining two macros | Excel Discussion (Misc queries) | |||
| Combining macros | Excel Discussion (Misc queries) | |||
| make macro run other macros in Exc 2007,no problems in Exc 2003 | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| Combining 3 macros to 1 | Excel Programming | |||
Threaded Mode
