Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro
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. |
#2
|
|||
|
|||
Sounds like you want to rename the macro Auto_Open then when you open the
workbook with the shortcut it will run automatically. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro and sub rountines | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions |