Using - Private Sub Workbook_Open()"

[SANDIND]

Hi All,

Can we use more than once "Private Sub Workbook_Open()" in one workbook. I
am trying to use to such written macros but I am getting error for the second
one. i was wondering is that only once we can use this.

I am new to VB plz help and Thanks in advance.

SS

 

[FSt1]

hi
only one workbook_open can be use that i am aware of.
if you have 2 macros that you want to run at open you can...
combine the 2 into one
or use the call command in the workbook open macro to call the second.

regards
FSt1

 

[SANDIND]

Thanks to both of you,

for your quick response, and giving such a valuable suggestion.

Have a great day..