Using - Private Sub Workbook_Open()"

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
 
F

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
 
S

SANDIND

Thanks to both of you,

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

Have a great day..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Private Sub Workbook_Open() 1
Auto_Open over Private Sub Workbook_Open() 2
workbook_open() sub does not work 2
VB Error 5 loading userform using Workbook_Open 1
Workbook_Open() does not work 3
Workbook_Open Event not firing 3
Separating Workbooks 4
a macro that runs automatically when a workbook is opened 2

Top