L
Laurie
When I copy a sheet, the macros in both the original sheet and the new
sheet no longer work. The macros are assigned to buttons, and
retrieve values representing the status of the button from cell links.
All macros use "active sheet" referencing to avoid reference errors
when copied or accessed from multiple sheets. Macro function is
restored after using "format control" to re-assign the cell links,
even though the appropriate cell link is indicated prior to
re-assignment. Any ideas about what's going on here?
sheet no longer work. The macros are assigned to buttons, and
retrieve values representing the status of the button from cell links.
All macros use "active sheet" referencing to avoid reference errors
when copied or accessed from multiple sheets. Macro function is
restored after using "format control" to re-assign the cell links,
even though the appropriate cell link is indicated prior to
re-assignment. Any ideas about what's going on here?