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 |
Excel macro
|
All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com