Copy sheet to a new book, but remove any macros associated with thatsheet

  • Thread starter Thread starter Tony Bender
  • Start date Start date
T

Tony Bender

I need help writing code that copies a sheet into a new book, but I
need to remove or disable the macro I have associated to the sheet.

Here is the code I have when the sheet from the master workbook is
opened:

Private Sub Worksheet_Activate()
Call FormatComment4
End Sub

So, somehow when I copy the sheet to a new workbook I need to unload
this code.

Thank you in advance,

Tony B
 
Back
Top