Would it be possible to do Application.ScreenUpdating =
False in PowerPoint called from VBA Excel?


>-----Original Message-----
>Try
>
>AppActivate Application.Caption
>
>
>--
>Cordially,
>Chip Pearson
>Microsoft MVP - Excel
>Pearson Software Consulting, LLC
>www.cpearson.com
>
>
>
>
>"Diego" <porno_abis@hotmail.com> wrote in message
>news:015b01c52e5f$a4641380$a601280a@phx.gbl...
>>
>> I am creating a tool in Excel to copy data/graph from
>> Excel to PowerPoint.
>>
>>
>> Dim PPApp As PowerPoint.Application
>> Dim PPPres As PowerPoint.Presentation
>>
>> Set PPApp = CreateObject("PowerPoint.Application")
>> PPApp.Visible = True
>> Set PPPres = PPApp.Presentations.Open(ppt_file)
>> ....
>>
>>
>> At the end of the code, I put:
>>
>> ThisWorkbook.Activate
>> Msgbox("You have finished running the tool")
>>
>> But it seems the screen still focuses in PowerPoint, so
I
>> have to manually switch to Excel to see the msgbox. How
do
>> I change the screen to the Excel file instead? Or, is it
>> possible to create the msgbox in PowerPoint instead?
>>
>> Also, I put Application.ScreenUpdating = False in my
code,
>> but it seems it onlhy works for Excel?
>>
>>
>> Thanks for the help
>>
>>
>>
>
>
>.
>