| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto run macro on open of workbook if cell a1=A
Sub RunWhenOpenDocument()
Select Case Range("Sheet1!A1").Value Case "a" Application.Run "INVENTRY.xls!newday.newday" Case "b" Application.Run "INVENTRY.xls!update.update" Case Else Range("Sheet1!C115").Select End Select End Sub Save this macro in Sheet1, and in ThisWorkbook, under the event Open, insert the line Sheet1.RunWhenOpenDocument Stephane Quenson -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200708/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
| auto-open macro lost within workbook | Excel Programming | |||
| auto run macro on workbook open | Excel Programming | |||
| auto run macro on workbook open | Excel Programming | |||
| auto run macro at workbook open | Excel Programming | |||
Hybrid Mode
