Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro
I have recently reinstalled Excel 2000. Before then I recorded a macro
and assigned it to a toolbar smily face button. The macro simply saved any open sheet on the G drive as "certificates" . The code simply was (SaveAs "G:\certificates.xls"). I recoded it using the macro menu, all very easy and worked fine. I am trying to re-record this macro but now the macro always saves itself in the certificates workbook. The result is the button opens the certificates workbook to run the macro and generates an error saying cannot overwrite an open file of the same name. How do I assign this macro again to any sheet that I have open in Excel? Thnaks. Sparks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to close excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |