to run a macro automatically on opening a workbook

[kmlprtsngh]

Hi all,
I have a workbook containing a macro.I am opening this workbook from other workbook.
I want that when i open the workbook, my macro in opened workbook runs automatically as soon as it is opened.

[digita]

Hi kmlprtsngh,

Go to VBE and click on thisworkbook under project explorer panel on the left.

Private Sub Workbook_Open()
your code
End Sub

Copy the above and put your code inside it.

Cheers

[kmlprtsngh]

Thanks, you are great.