View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 102
Default Macro Name problem when I change workbook name?

Tom,

My Macro doesn't have a code! My macro just performs few operations
using Tools, Macro, Record New Macro...etc.

I opened ABC.xls file and saved it as, using saveas, as DEF.xls

Next, I pushed the button that my macro is linked to but gave me again
an error "out of range" and the file closed!
HOW can I prevent this?

Thanks,
Mike