Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic replacing of a VBE sub in all open workbooks
hi all !
i know how to make automatic replacing of a cell for all open workbooks.. now i neeed to replace a sub with another 1 with a little difference.. is there a way to make it ? tx ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic replacing of a VBE sub in all open workbooks
You can write another Sub procedure and call it from a third procedure based
on conditions: Sub master() If Range("A1") < "Condition" Then Macro1 Else Macro2 End If End Sub Sub Macro1() MsgBox "Macro1" Range("A1") = "Condition") End Sub Sub Macro2 MsgBox "Macro2" Range("1").ClearContents End Sub "pls123" wrote in message ... hi all ! i know how to make automatic replacing of a cell for all open workbooks.. now i neeed to replace a sub with another 1 with a little difference.. is there a way to make it ? tx ! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic replacing of a VBE sub in all open workbooks
tx for help !
"JLGWhiz" wrote: You can write another Sub procedure and call it from a third procedure based on conditions: Sub master() If Range("A1") < "Condition" Then Macro1 Else Macro2 End If End Sub Sub Macro1() MsgBox "Macro1" Range("A1") = "Condition") End Sub Sub Macro2 MsgBox "Macro2" Range("1").ClearContents End Sub "pls123" wrote in message ... hi all ! i know how to make automatic replacing of a cell for all open workbooks.. now i neeed to replace a sub with another 1 with a little difference.. is there a way to make it ? tx ! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
Excel - replacing Text in workbooks | Excel Worksheet Functions | |||
Automatic replacing a file while in a macro | Excel Programming | |||
Replacing (identical) values in multiple workbooks simultaneously? | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |