Presentation Mode Updates

JohnWilson · #4 05-10-2019, 08:34 AM

I'm really not an Excel coder but if you put this in the ThisWorkbook where the linked data is it should update the current PPT (even in show mode). Make sure you change the slide and shape number to match what you have or it will error.

Code:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Dim PPTApp As Object
Dim PPTPres As Object
Set PPTApp = CreateObject(Class:="PowerPoint.Application")
Set PPTPres = PPTApp.ActivePresentation
' Change to match linked shape
PPTPres.Slides(1).Shapes(3).LinkFormat.Update
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use of pointer in presentation mode	pedalpower	PowerPoint	2	03-21-2025 06:58 AM
Text Box I can edit in Presentation Mode	llomax83	PowerPoint	0	10-24-2016 01:24 PM
Hyperlinks in presentation mode	michaelwoosley	Visio	0	09-07-2014 10:36 AM
How to move stuff around while in presentation mode?	jcodi	PowerPoint	1	03-08-2013 01:16 AM
word 2010 presentation mode	chaci	Word	1	03-26-2012 02:48 PM