Workbook Event running VBA question

Dear Gurus,

i have a question, i have a workbook where i want multiple Macros to run once the workbook is opened. i am not sure how do i put it. i have a macro that protects the sheet and the the next macro is to check the username and if not desired user then workbook to close.

in the workbook event windows



i am wondering whether i can put the command of call or run for the macros

Workbook_Open

run Macro1

run macro2

end sub

or to use call instead of run. i am bit confused here. can you help please.

thanks.

Seasons's Greetings

Hi,

You can check below link. Download the file and provide user name Lalit Mohan

https://groups.google.com/forum/#!to...os/BUiOJAAQHcw

Open this file Press Alt + F11 and in left side double click on ThisWorkbook and see the code for Workbook_Open Event.

You can do it like this:

Code:

---


Private Sub Workbook_Open()

    Call Macro1

    Call macro2
   
End Sub

---

@ Lalit,

Please feel free to upload the workbook here :)

Mr. Pandey,

thank you very much. you have been very active and supportive member of this forum. i wish and hope that it stays this way.

cheers,

Quote:

---

Originally Posted by LalitPandey87

You can do it like this:

Code:

---


Private Sub Workbook_Open()

    Call Macro1

    Call macro2
   
End Sub

---

---