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.

--
HTH

Bob Phillips

"Pam Coleman" wrote in message
...
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.

--
HTH

Bob Phillips

"Pam Coleman" wrote in message
...
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.