Excel macro

[sparkchap]

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

 

[Paul Lautman]

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

When you record it, choose to save it in your Personal Macro Workbook