| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically change autoshape color to that of another autoshape
Hi All
I have autoshapes (oval) in sheets 2-50, which changes color when you click on them . In sheet1 have a summary of sheets 2-50 (with 48 ovals) I am trying to get the ovals in sheet1 to automatically change color to the one selected in the corresponding sheet. e.g. Sheet1 Oval1 = Sheet2 Oval1 (fill color) Sheet1 Oval2 = Sheet3 Oval1 (fill Color) and so on... Can someone please help T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically put AutoShape in certain spots | Excel Discussion (Misc queries) | |||
| Change color of an autoshape | Excel Programming | |||
| Change color of Autoshape in chart | Excel Programming | |||
| How do I change the color Excel Autoshape using VBA? | Excel Programming | |||
| Change AutoShape Text Color in VBA? | Excel Programming | |||
Threaded Mode
