Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRIGGER MACRO ON FILE OPEN
I am trying to create a macro that will trigger when I open a workbook, but I
am not at all familiar with Visual Basic. Is there a way to do this without writing VB code? Thanks! -- Drew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRIGGER MACRO ON FILE OPEN
"Drew" wrote in message ... I am trying to create a macro that will trigger when I open a workbook, but I am not at all familiar with Visual Basic. Is there a way to do this without writing VB code? Thanks! -- Drew Drew Are you familar with the visual Basic editor.? If so you need to place code in the workbook_open event . Private Sub Workbook_Open() your code End Sub Such a macro would fire every time to load the workbook Best N10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Macro to call a file that has a auto open macro in the file itself | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |