Macro to select all shapes (text boxes) in workbook

**Humahuaca** · 03-21-2012, 12:27 PM

Hello,

This is my first post.

I am currently working on the workbook with multiple tabs (over 70) on each tab, there's a number of charts related to the data on that tab.

I would need to select all the textboxes in all the charts to do some formatting changes.

I tried a "pedestrian" search by formatting function but it doesn't seem to search through anything but cells.
Is there a macro I could use for this purpose?

Thank you in advance for your help.

**dilipandey** · 03-25-2012, 07:01 AM

Hi Humahuaca,

Welcome to the forum.
All the textboxes are actually objects and objects can be selected by F5-> Special - > Ojbects -> Enter

Regards,
DILIPandey

<click on below 'star' if this helps>

**Andy Pope** · 03-28-2012, 04:21 AM

Select special objects will only select the chartobject and not the textboxes within it. You will also not be able to specify what type of objects are selected.

This code will goes through sheet, charts, chartobjects and shapes.

Please Login or Register  to view this content.

Macro to select all shapes (text boxes) in workbook

LinkBack

Thread Tools

Rate This Thread

Display

Macro to select all shapes (text boxes) in workbook

Re: Macro to select all shapes (text boxes) in workbook

Re: Macro to select all shapes (text boxes) in workbook

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions