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

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" wrote:

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