Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto macro opening excel workbook
I would like to run automaticaly a macro when opening a workbook.
I have found answers, but I don't understand them. Please detail me the step in excel and visual basic to make this possible. Thank you very much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto macro opening excel workbook
Private Sub Workbook_Open() 'your code here End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Baris" wrote in message ... I would like to run automaticaly a macro when opening a workbook. I have found answers, but I don't understand them. Please detail me the step in excel and visual basic to make this possible. Thank you very much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto macro opening excel workbook
Open the VBA Editor. Go to the Insert menu and choose Module (not
Class Module). In that module, place the following code: Sub Auto_Open() ' the code you want to run End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Baris" wrote in message ... I would like to run automaticaly a macro when opening a workbook. I have found answers, but I don't understand them. Please detail me the step in excel and visual basic to make this possible. Thank you very much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a Workbook with a Macro | Excel Discussion (Misc queries) | |||
Auto Protect workbook with password upon opening | Excel Worksheet Functions | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
Macro to email excel workbook with static recipient and auto subject | Excel Programming | |||
Auto opening macro when loading a workbook | Excel Programming |