auto-launch a MACRO?

  • Thread starter Thread starter d-cubed
  • Start date Start date
D

d-cubed

Can I automatically run a macro when the file is opened?
If so, how? Also, if so, would I ever be able to disable
the macro?

d-cubed
 
Thanks for the tip, it sounds like it will work!

I guess my knowledge is a bit limited - how do I "put it
in the Workbook_Open event"?

dan
 
d-cubed said:
Can I automatically run a macro when the file is opened?
If so, how? Also, if so, would I ever be able to disable
the macro?
Click to expand...

Yes, put it in the WorkBook_Open event. To disable it, remove it or turn
it into a comment.

Regards,
 
d-cubed said:
Thanks for the tip, it sounds like it will work!

I guess my knowledge is a bit limited - how do I "put it
in the Workbook_Open event"?
Click to expand...

Go to the Visual Basic Editor and on the left on the projects window,
press twice over ThisWorkbook, then on the Combobox on top of the
window, change General for Workbook. The "Private Sub Workbook_Open"
should appear all by itself. Now add the code or call the procedure in
there.

Regards,
 
Back
Top