Workbook Event running VBA question

[jamilm]

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

[LalitPandey87]

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.

[LalitPandey87]

You can do it like this:

Private Sub Workbook_Open()

    Call Macro1

    Call macro2
    
End Sub

[Admin]

@ Lalit,

Please feel free to upload the workbook here

[jamilm]

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,

You can do it like this:

Private Sub Workbook_Open()

    Call Macro1

    Call macro2
    
End Sub