Hello,

I have written a macro to get rid of fill colors very quickly, working with

oshp.Fill.Visible = msoFalse
But this is not the same as clicking "no fill" in the coloring menu. With "no fill" in the coloring menu, one really deletes the color information, while it is still there, when I use "Visible = false"

How can I really get rid of the color information? I tried

oshp.Fill.ForeColor.RGB = msoFalse
but that's just a black shape, setting RGB to 0, 0, 0.

Intention is to get completely rid of the coloring information, because I have a different macro, searching for shapes with the same color as a selected shape. It works well with one exception: It selects shapes with invisible fills of the same color, too.

It is probably just one line, but I have no idea yet.