Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Change multiple object group name
Hi all,
Whilst the code below changes all button names from GW2opt to GW4opt is there a way to change group names e.g. change group 1a to 1a4 but using a wildcard char to replace 1a since I have groups 1b, 1c, etc. Simply, Iwant to add 4 to all group names! Public Sub ChangeButtonName() Dim OleObj As OLEObject For Each OleObj In ActiveSheet.OLEObjects With OleObj .Name = Replace(.Name, "GW2opt", "GW4opt") End With Next OleObj End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Icon for inserted file object doesn't collapse away when closeoutline group | Excel Discussion (Misc queries) | |||
Object error with Group & Ungroup in Excel | Excel Worksheet Functions | |||
Change multiple object group name | Excel Discussion (Misc queries) | |||
Data, Group got error message Cannot shift object off sheet | Excel Discussion (Misc queries) | |||
what object group does this reside in | Excel Programming |