automatic macros day 2

[itsme]

Thanks everone, it finally works!!!!
Great

Another question about this:
If I want to have more then one macro run when the file opens do I just add more at the same spot in this workbook?

Example:

Public sub workbook_open()
Macro18
end sub

Public sub workbook_open()
Macro41
end sub

I kind of doubt it, this would be too easy!
LOL

Thanks

 

[David McRitchie]

You asked same question in you original thread where it was answered
to call two macros (or just combine the macros)..

It is (usually) best to stick to a single thread when continuing something. So that
someone searching archives can see everything in context.

When you have a completely unrelated question then start a new thread.

 

[itsme]

thanks
sorry

You asked same question in you original thread where it was answered
to call two macros (or just combine the macros)..

It is (usually) best to stick to a single thread when continuing something. So that
someone searching archives can see everything in context.

When you have a completely unrelated question then start a new thread.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Thanks everone, it finally works!!!!
Great

Another question about this:
If I want to have more then one macro run when the file opens do I just add more at the same spot in this workbook?

Example:

Public sub workbook_open()
Macro18
end sub

Public sub workbook_open()
Macro41
end sub

I kind of doubt it, this would be too easy!
LOL

Thanks

 

[Berend Botje]

I already answered this in your other thread