Automatically resize pictures or shapes to fit a page

[Thiverdrive]

Hey there all
I have been all over the net trying to find a way to automatically fot a picture to pre-determened border on a visio page but so far no luck. Does anyone here know if this is even possible in Visio?

[Paul Herber]

Auto resizing a shape to do this is easy. Just set the Width and Height shapesheet cells to be formulae that reference the page width and height.
e.g. Width=ThePage!PageWidth-10mm
or similar.
If you can put the picture into a Visio shape then this is the way to do it.

[Surrogate]

Visio out-of-box, can't do it.
But if you write code in vba it can be available!

[Thiverdrive]

Thanks for the replies I have not played with the VBA side of visio ever so time to start I guess;)

[wapperdude]

Couple things to consider...
1)  maintaining aspect ratio
2)  centering on page
3)  orientation:  portrait vs landscape
4)  how to invoke...
      a) automatic => suggests on drop.  Easily done.  But, limiting to just photo object...very difficult, if not impossible. Thus, all
          new objects (shapes) get resized
      b) semi-automatic => use combination of keys to run macro on selected object, e.g. <cntl>+<shift>+<H>.

Just some things to consider.

Wapperdude