PC Review


Reply
Thread Tools Rate Thread

can i use a macro to auto resize a pic?

 
 
theintern
Guest
Posts: n/a
 
      8th Jul 2008
I need a macro to autoresize a pic to fill up as much of the top half
(approximately) of a slide as possible. Is there a way to do this?

thanks
scott
 
Reply With Quote
 
 
 
 
theintern
Guest
Posts: n/a
 
      8th Jul 2008
How do I "use the "hammer" button to make any other shape fit into that
defined/memorized area"? Each time i click on it, it tells me i need to
select an object. How do i define the area i want it to fill?

thanks
scott

"Steve Rindsberg" wrote:

> In article <63276A45-2DBC-4A74-9AFF-(E-Mail Removed)>, Theintern
> wrote:
> > I need a macro to autoresize a pic to fill up as much of the top half
> > (approximately) of a slide as possible. Is there a way to do this?

>
> Have a look at the free PPTools StarterSet add-in
>
> http://www.pptools.com/starterset/
>
> It includes a couple of buttons that can do this for you automatically.
>
> You create a rectangle that defines the target area you want to size things
> into and memorize its position/size. Then delete it.
>
> Then you can use the "hammer" button to make any other shape fit into that
> defined/memorized area (as large as possible w/o distortion or simply as large
> as possible, distorted or not, your choice)
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

 
Reply With Quote
 
theintern
Guest
Posts: n/a
 
      8th Jul 2008
I may have it figured out now, but i need it in a macro, and thanks to there
being no recording tool, and my complete lack of VBA, you know what lines of
code would allow for the picture just pasted to a slide to then be auto
resized to that shape? you can assume the pic is already pasted. i just
need the code to resize it.

thanks
scott

"Steve Rindsberg" wrote:

> In article <63276A45-2DBC-4A74-9AFF-(E-Mail Removed)>, Theintern
> wrote:
> > I need a macro to autoresize a pic to fill up as much of the top half
> > (approximately) of a slide as possible. Is there a way to do this?

>
> Have a look at the free PPTools StarterSet add-in
>
> http://www.pptools.com/starterset/
>
> It includes a couple of buttons that can do this for you automatically.
>
> You create a rectangle that defines the target area you want to size things
> into and memorize its position/size. Then delete it.
>
> Then you can use the "hammer" button to make any other shape fit into that
> defined/memorized area (as large as possible w/o distortion or simply as large
> as possible, distorted or not, your choice)
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

 
Reply With Quote
 
theintern
Guest
Posts: n/a
 
      8th Jul 2008
works beautifully. Thanks!

"Steve Rindsberg" wrote:

> In article <61933290-FF3B-48D9-8728-(E-Mail Removed)>, Theintern wrote:
> > I may have it figured out now, but i need it in a macro, and thanks to there
> > being no recording tool, and my complete lack of VBA, you know what lines of
> > code would allow for the picture just pasted to a slide to then be auto
> > resized to that shape? you can assume the pic is already pasted. i just
> > need the code to resize it.

>
> Assuming the shape is also selected, you can do something like:
>
> With ActiveWindow.Selection.ShapeRange(1)
> ' this will be true or false depending on what
> ' you're after:
> .LockAspectRatio = msoFalse
> ' set the size/position
> .Left = xx
> .Top = xx
> .Height = xx
> .Width = xx
> End With
>
> You'd need to calculate the values for each parameter. If you don't care whether
> the shape is distorted or not, so long as it fits your target area, then just use
> the left, top, height and width of your target area directly. In that case, also
> set .LockAspectRatio to msoFalse
>
>
>
> >
> > thanks
> > scott
> >
> > "Steve Rindsberg" wrote:
> >
> > > In article <63276A45-2DBC-4A74-9AFF-(E-Mail Removed)>, Theintern
> > > wrote:
> > > > I need a macro to autoresize a pic to fill up as much of the top half
> > > > (approximately) of a slide as possible. Is there a way to do this?
> > >
> > > Have a look at the free PPTools StarterSet add-in
> > >
> > > http://www.pptools.com/starterset/
> > >
> > > It includes a couple of buttons that can do this for you automatically.
> > >
> > > You create a rectangle that defines the target area you want to size things
> > > into and memorize its position/size. Then delete it.
> > >
> > > Then you can use the "hammer" button to make any other shape fit into that
> > > defined/memorized area (as large as possible w/o distortion or simply as large
> > > as possible, distorted or not, your choice)
> > >
> > > -----------------------------------------
> > > Steve Rindsberg, PPT MVP
> > > PPT FAQ: www.pptfaq.com
> > > PPTools: www.pptools.com
> > > ================================================
> > >
> > >
> > >

> >

>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Resize =?Utf-8?B?R2Vvcmdl?= Microsoft Access Reports 7 27th Jun 2007 12:14 PM
Auto resize and position controls upon form's Resize even helpful sql Microsoft Dot NET 4 31st Mar 2006 01:45 AM
Auto resize and position controls upon form's Resize even helpful sql Microsoft C# .NET 3 31st Mar 2006 01:45 AM
Auto resize and position controls upon form's Resize even helpful sql Microsoft VB .NET 3 31st Mar 2006 01:45 AM
Auto resize, auto realign, auto ANYTHING driving me crazy spasmous@yahoo.com Microsoft Powerpoint 2 30th Apr 2005 02:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 PM.