automatic macro

  • Thread starter Thread starter luke
  • Start date Start date
L

luke

I can only get my background vb code to run by activating
a macro with a control (button, etc).
how can I get code to run automatically from excel
startup and continue running in the background?

any help would be great
 
Two ways
change the name of the sub to auto_open
place the code in ThisWorkbook in the sub Workbook_Open
Paul D
 
cheers. great help
-----Original Message-----
Two ways
change the name of the sub to auto_open
place the code in ThisWorkbook in the sub Workbook_Open
Paul D




.
Click to expand...
 
You must log in or register to reply here.

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

Run Macro If Cell have "x" value 0
Need to run a macro on opening a new excel file 0
GridLines Inadvertantly Goes Away with Macro 3
VB macro script to find column A in Excel when row not known 3
Time Out a MsgBox 7
Excel Macros to zip a file 0
Re: Reference must be to a macro sheet? 0
Access Automatically Send a notification email once a record is added 0

Back
Top