View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] amanda.graor@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to keep macros attached when moving sheet to a new workbook

I need to move sheets back and forth between different workbooks, and I
have no idea how to keep the macros attached to the graphical buttons
on the sheet itself. When I use the buttons (they have macros attached
to add new row), it searches for the old file it came from, even if the
correct macros are attached to the sheet, and I have to re-link the
buttons. Any ideas how to make the path automatically re-assign itself
to the macros in the new workbook?