Loop through shapes and alter interior color

**Macdave_19** · 03-23-2009, 08:27 AM

Hi All,

i have loads of oval shapes on a sheet and i am trying to loop through them when i open the workbook and change the interior color to red.

however i'm getting an error and i can't figure out why?

Please Login or Register  to view this content.

any ideas why?

cheers for reading all

**StephenR** · 03-23-2009, 08:30 AM

Not tested, but I'm guessing you need to reference the Shapes collection:

Please Login or Register  to view this content.

**Macdave_19** · 03-23-2009, 08:33 AM

Spot on steve!!!

appreciate the help

Loop through shapes and alter interior color

LinkBack

Thread Tools

Rate This Thread

Display

Loop through shapes and alter interior color

Re: Loop through shapes and alter interior color

Re: Loop through shapes and alter interior color

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions