Auto Run a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a warrant file saved to our server. I want to run a Macro that when I
click on the excel shortcut on the desktop named warrants, the macro will
automatically run to open the file, then replace the old one on the server
save and then close excel. I can get the macro to work if I open excel,
choose the macro and run it. How do I make it work automactically when I
double click the excel warrant sheet on the desktop? Thanks, I am confused.
 
Name the macro in the workbook Auto_Open and it will run automatically on
opening.
 
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

Macro 1
Excel 2007: Help creating a macro that will run Solver? 3
Dynamic Excel data into locked Word form 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Run Macro If Cell have "x" value 0
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Macro not running 1
Run a macro from another workbook in the QAT 1

Back
Top