Display UserForm on Open in ppt 2007

peteyb · 07-08-2008, 05:18 AM

Hi All

When using MS Word 2007 I can put the following code in the ThisDocument areas in VB, which displays the userForm when the document is opended.

Code:

Private Sub Document_Open()
    UserForm.Show
End Sub

Why wont this work in Powerpoint? Is it possible for a userForm to open in Powerpoint whent he presentation is opended?

David M58 · 07-08-2008, 10:54 AM

PowerPoint does not support a "document open" or "auto open" event that is directly accessible without loading an add-in.

One thing you could do in PowerPoint 2007 is create a desktop shortcut that opens the presentation and runs a macro which could open a UserForm. The shortcut target would be something like:

"C:\Program Files\Microsoft Office\Office12\POWERPNT.EXE" /M "C:\Presentations\Petey_B.pptm" "FormOpen"

In the above example, "FormOpen" is the name of a macro.

peteyb · 07-09-2008, 02:01 AM

I have found an alternative solution, in that the user will simply press Alt+F8 then run the macro.

Although I will keep what you said in mind for any future ppt's.

07-08-2008, 05:18 AM	#1 (permalink)
peteyb Registered User Join Date: Apr 2007 Posts: 60 OS: xp pro	Display UserForm on Open in ppt 2007 Hi All When using MS Word 2007 I can put the following code in the ThisDocument areas in VB, which displays the userForm when the document is opended. Code: Private Sub Document_Open() UserForm.Show End Sub Why wont this work in Powerpoint? Is it possible for a userForm to open in Powerpoint whent he presentation is opended?

07-08-2008, 10:54 AM	#2 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 160 OS: Windows XP SP3	Re: Display UserForm on Open in ppt 2007 PowerPoint does not support a "document open" or "auto open" event that is directly accessible without loading an add-in. One thing you could do in PowerPoint 2007 is create a desktop shortcut that opens the presentation and runs a macro which could open a UserForm. The shortcut target would be something like: "C:\Program Files\Microsoft Office\Office12\POWERPNT.EXE" /M "C:\Presentations\Petey_B.pptm" "FormOpen" In the above example, "FormOpen" is the name of a macro.

07-09-2008, 02:01 AM	#3 (permalink)
peteyb Registered User Join Date: Apr 2007 Posts: 60 OS: xp pro	Re: Display UserForm on Open in ppt 2007 I have found an alternative solution, in that the user will simply press Alt+F8 then run the macro. Although I will keep what you said in mind for any future ppt's.