I have a marco I wrote in Excel 2003 that still works there, but no longer functions in 2007. This macro is embeded in a workbook and runs when the workbook opens. Essentially, it checks if a later version of the workbook is abailable and transfers the data from the "old" to the "new" workbook. There seem to be two hang-ups. Both the worksheet.unprotect and the workbook.save both throw a 1004 error when called in 2007. Anyone with similar experience? Any useful advice?
Thanks,
Dave
Bookmarks