Using - Private Sub Workbook_Open()"

  • Thread starter Thread starter SANDIND
  • Start date Start date
S

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
 
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
 
Thanks to both of you,

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

Have a great day..
 
Back
Top