copy worksheet without macro on the sheet

[andre5]

Good day

I have a macro that runs when a sheet is activated. The second macro I run I copy the sheet to a new workbook.

How can I copy the sheet without the macro or delete the macro in the new workbook?

Your help is much valued!

Andre

 

[agihcam]

Hi -

this code will copy the activesheet to new workbook without a macro.

Sub copynomacro()
Set wb = ThisWorkbook
Set wbnew = Workbooks.Add
wb.ActiveSheet.Copy before:=wbnew.Sheets(1)
End Sub

 

[andre5]

Thank you, but the macro on the sheet copie still with the sheet any other ideas

 

[agihcam]

hhmmm. not mine.
ok. try this;
click tools > macro > macros click every macros you have and see if macros in: is This Workbook, if All Open Workbooks, change this to This Workbook then run the code again.