How to remove textbox with copy a sheet to a file

  • Thread starter Thread starter michelle_ho
  • Start date Start date
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
 
Hi michelle

If it is one textbox you can use this

ActiveSheet.Copy
ActiveSheet.Shapes("TextBox1").Delete
 
thx, but what if I don't know the textbox number? I want to delete al
of them. Is there any method to do so
 
michelle_ho < wrote
thx, but what if I don't know the textbox number? I want to delete all
of them. Is there any method to do so?
Click to expand...

or just activesheet.textboxes.delete
 
I have another question then....

Suppose I have a textbox29, with text:

------------------------------------
This is a textbox's top



This is a textbox's bottom
------------------------------------

I want to add one more row to the textbox, such that the conten
become:

------------------------------------
This is a textbox's top
I added a new line here


This is a textbox's bottom
 
Back
Top