How to remove textbox with copy a sheet to a file

M

michelle_ho

In my excel, there is a textbox on the worksheet.

I have written a code, so that it will copy this worksheet to a ne
workbook.

For this new workbook, I want to remove the textbox, how can I do so?

Thx a lot
 
R

Ron de Bruin

Hi michelle

If it is one textbox you can use this

ActiveSheet.Copy
ActiveSheet.Shapes("TextBox1").Delete
 
Top