How to edit embedded PowerPoint presentation in Excel without screen updates?

Alice 99

New Member
Joined
Nov 19, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have a PowerPoint Object embedded in excel sheet1.
(=EMBED("PowerPoint.Show.12","")

The idea is to edit the PowerPoint presentation from within Excel using VBA in Excel:
Copy a range from Excel and Paste into a PowerPoint slide

When using Verb:=xlOpen, the range gets inserted into the PowerPoint sheet and also shows in the embedded object, so far so good. But the screen gets updated whilst doing that.

If possible, I do not want Excel to show all the activity involved during this open, copy-paste process.
Application.ScreenUpdate=false does not help with this.

I’ve tried Verb:=xlPrimary, but that opens PowerPoint in the slide show mode!

Any suggestion how to edit an embedded PowerPoint file from within Excel VBA, without showing all the screen updates?

Thank you kindly!
Alice

VBA Code:
Sub EmbedPowerPoint()
Dim myObject As OLEObject
Dim p As PowerPoint.Presentation
Dim rng As Range

Application.ScreenUpdating = False

Set myObject = Sheet1.OLEObjects("Object 1")

'myObject.Verb Verb:=xlOpen '
myObject.Verb Verb:=xlPrimary

Set p = myObject.Object

Set rng = Sheet3.Range("A1:F7")
rng.Copy

Set MySlide = p.Slides(1)
MySlide.Shapes.PasteSpecial DataType:=2

[a1].Select
Set myObject = Nothing
Application.ScreenUpdating = True
End Sub
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

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