Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I recorded this macro:
ActiveSheet.Shapes("Control 3").Select Selection.Cut ActiveSheet.Shapes("Picture 1").Select Selection.Cut ActiveSheet.Shapes("Picture 2").Select Selection.Cut but it hang's (item with the spcified name wasn't found) I assume by downloading various data, the numbers of the objects change, and that's probably why it's hanging. Different data but all with the same control box and pictures. Is there a way to run a macro that will delete the control box and pictures. Perhaps writing it as : Cut any control, any picture, any button ? Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Multiple Pictures | Excel Discussion (Misc queries) | |||
Macro to delete various pictures and hyper-link picture icons | Excel Worksheet Functions | |||
Delete pictures in spreadsheet | Excel Discussion (Misc queries) | |||
delete pictures with a macro | Excel Discussion (Misc queries) | |||
Macro to delete pictures ? | Excel Worksheet Functions |