View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
EricG EricG is offline
external usenet poster
 
Posts: 220
Default Rotate Fill Effect With Shape in VBA

Thanks for the input.

When I'm in the debugger, my block arrow shape does not have a
"RotateWithObject" property underneath the "Fill" property, so there is not
way to set it. I'm not sure if this is because it's an autoshape or what,
but if the property is not there, then there is no way to set it. Perhaps
it's just not exposed in the VBA object model?

I'll keep looking, but you are probably right about the bug.

Thanks,

Eric

"Peter T" wrote:

In theory this should do it

shp.Fill.RotateWithObject = msoTrue ' msoFalse

http://msdn.microsoft.com/en-us/library/bb242619.aspx

However the code fails for me trying to write. Read the value always returns
msoFalse 0 irrespective of the actual setting. Looks like a bug.

Regards,
Peter T