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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
>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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks