PowerPoint double click macro

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Hi all,

Many thanks as always for any responses.

I have a PowerPoint with a single image per slide, each image on a slide needs to be made to fit the size of my powerpoint window and at the moment im doing it manually.

I was thinking perhaps a macro - I double click on an image and it re sizes to fit the size of my slide.

Is this posible? Can anyone help point me in the right direction please
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Hi
This will fit all images on the presentation. Depending on the height/width of your actual pictures, this macro may need some tweaking, tell me if it is the case.

Code:
Sub ResizeAll()
Dim sl As Slide
For Each sl In ActiveWindow.Presentation.Slides
    With sl.Shapes.Item(1)
    Rem Blank slides with only one picture
        .LockAspectRatio = msoTrue
        .Height = ActiveWindow.Presentation.PageSetup.SlideHeight
        .Width = ActiveWindow.Presentation.PageSetup.SlideWidth
        .Left = 0
        .Top = 0
    End With
Next
End Sub
 
Upvote 0
This was exactly what I needed, thank you very much.

I have saved this as an add in PPAM and managed to use the custom XML editor to add it as an option to my right click menu with some googling and a little patience. :)

I want to send my macro to a small team of around 30 people my problem is they are not vry computer literate.

Is there an easy way to distribute an add in so i dont have to provide everyone with instructions on how to load an add in?

I was thinking maybe install as an EXE? Ive done som resarch but im stumped :( What is the bst way to distribute or share an add in with a wider audience?

Any guidance very welcome and appreciatd.

Thanks :)
 
Upvote 0

Forum statistics

Threads
1,225,657
Messages
6,186,257
Members
453,347
Latest member
mrizkiii28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top