Use VBA to hide or make invisible and open excel and power point to work on it behind the scene.

[JohnSeito]

How can we use VBA to make invisible or hide an open excel file and power point presentation behind the scene while we work on it.


It works well with excel as I use ActiveWindow.Visible = False but for power point I use

set pres = pap.presentations.open(pth + pptxfile, withwindow:msofalse)

the window is hidden but I can't do anything to the power point presentation.

 

[SecDark]

It works in my case, just be aware that you cannot use "activepresentation" if you hide the presentation. You should use the variable instead