Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Workbook_Open()
Hi I want this Macro to run when the Workbook is opened:
Private Sub Workbook_Open() MsgBox "Hi I am here" End Sub The workbook opens asks me if I want to run macros - I enable but nothing else happens. what must I do to make the macro run? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Workbook_Open()
You should paste the code to the Workbook module..In Visual Basic Editor from
the left treeview search for the workbook name and click on + to expand it. Within that you should see the following VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) This Workbook Double click 'This WorkBook' and paste the same code to the right code pane. -- Jacob "Helmut" wrote: Hi I want this Macro to run when the Workbook is opened: Private Sub Workbook_Open() MsgBox "Hi I am here" End Sub The workbook opens asks me if I want to run macros - I enable but nothing else happens. what must I do to make the macro run? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Private Sub Workbook_Open() doesn't run | Excel Discussion (Misc queries) | |||
Using - Private Sub Workbook_Open()" | Excel Programming | |||
Failure to execute Private Workbook_Open | Excel Programming | |||
XL97 Private Sub Workbook_Open() Not Working | Excel Programming | |||
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star | Excel Programming |