"Rolf Marvin Bøe Lindgren" writes:

"NickHK" writes:

Rolf,
It's from the Microsoft Office library, defined as a MsoAutoShapeType, with
value=1. Maybe you do not have a reference set to this library.

OK, but how do I establish such a referance? as stated, this works in
a workbook that's been made by somebody else - it's in the workbook
that I'm working on that it doesn't work.

found it. Tools - References - ... lots of stuff.

thanks!

--
Rolf Lindgren http://www.roffe.com/