Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default in excel 2007, how to remove all the text box in one operation ?

I have many text box to remove and I look for a simple function to do it
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default in excel 2007, how to remove all the text box in one operation?

Find and Select, Selection pane.

garnier michel wrote:

I have many text box to remove and I look for a simple function to do it


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default in excel 2007, how to remove all the text box in one operation ?

Via macro:

Sub DelTextBoxes()
ActiveSheet.TextBoxes.Delete
End Sub


--
Jim
"garnier michel" <garnier wrote in message
...
|I have many text box to remove and I look for a simple function to do it

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to remove text with strikethrough - Excel 2007 HD[_2_] Excel Worksheet Functions 6 July 18th 08 07:37 AM
Excel 2007 not retaining formatting in mail merge operation Susan Excel Discussion (Misc queries) 3 November 4th 07 06:17 AM
How to remove the ' ^ etc. in Excel 2007? Laibeus Lord Setting up and Configuration of Excel 1 March 18th 07 06:05 PM
how do i remove a cell name in Excel 2007? kermit Excel Discussion (Misc queries) 2 March 8th 07 10:14 PM
can excel produce text in a given cell as a result of a boolean operation? Richard Erlacher Excel Discussion (Misc queries) 5 October 26th 06 09:39 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"