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

[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

 

[Gord Dibben]

Instead of copying the sheet can you just copy the sheet contents and
formatting to a new sheet in a new book?

To remove code see Chip Pearson's site

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP