View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luca[_6_] Luca[_6_] is offline
external usenet poster
 
Posts: 1
Default automatic shape property settings

Hi,

I would like to have some properties of "autoshapes" linked to cells
values, e.g. size, rotation, visibility etc.
I know that Visio has native support for this feature, is it
implemented in excel too?

As alternative approach, I imagine that I have to write some macro and
link change events on the monitored cells to code which sets the
properties of shapes, am I right?

Another shapes-related question: I know that it is possible to draw by
code, but I would like to know if there is a "shape editor" able to
create shapes usable directly in Excel or if there are somewhere
libraries of shapes to enrich the native ones. Or course cliparts can
do the job for several tasks, but sometimes a richer shape library is
a better solution.

Bye & tks for your kind attention.

Luca