Error everyone,
I've created a macro toolbar, so it appears all the time I open an excel file. That is great.
But here is my concern: I would like to use the button I created on that toolbar to save the activeworksheet . When I use the following code:
ActiveWorkbook.SaveCopyAs "c:\Completed\FinalCopy.xls" , it save the macro at that location and not my worksheet.
Please need your help.
Thanks!
Bookmarks