Posts by leobardoo

Nice, what is the workaround?

Ok, thanks!

Quote from royUK

I've managed to get this to work adapting this suggestion

Run Code When PowerPoint Opens

If you download the CustomUI Editor that is needed you will see that I made slight a change to the xml

Wow that's amazing!! Just one little thing, how do I manage to not close the presentation when clicking in "No"?

I see... Anyways, thank you very much!

That's the point. I'm working with powerpoint. Please, see the print in the link bellow. In ppt I dont have the same option of excel to select the WorkBook on the dropdown.

Image:

https://imghub.io/i/9oYVt

I want a pop-up message when the user clicks to close the file. When that happens a message with a Yes/No choice "Have you uploaded the data?" "Yes" or "No". If clicks no (returns to file) if yes close the file.

Quote from royUK

You don't need to change the event code name.

The code looks like it should be asking the user whether he wants the workbook to close. If they click no, then the close is cancelled and the workbook remains open.

Thanks. What is event code name? I'm very new with this. What should I do for this to work?

So what I want to do is to have a message box that pops up when this PowerPoint file is attempted to close that says "Have you uploaded the data?" "Yes" or "No".

If they click "Yes" then Excel closes, if they click "No", it then cancel the closing operation.

I'm very newbie with VBA, if you cloud explain step-by-step to me I would appreciate it.I've trying this code, but it does not work:

Private Sub PPTApp_BeforeClose(Cancel As Boolean)
If MsgBox("Text", _
vbQuestion + vbYesNo) = vbNo Then
Cancel = True
End If
End Sub