View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lman Lman is offline
external usenet poster
 
Posts: 13
Default Display an Excel form from PowerPoint

Prehaps i should be more clear, the hyperlink you will create is a hyperlink
to the actual excel file wherever it resides on your local or network drive.

"Lman" wrote:

Think i might have answered this somewhere else but anyway if you instert the
following code into your worksheet

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMinimized
UserForm1.Show
End Sub

(where userform1 is the name of your form).

You will then be able to create a hyperlink from the powerpoint slide and
should load the form on top of your slide..at least it worked for me anyway

hope this helps

"lorraine" wrote:

I currently have an excel form that I would like to open up and use from
powerpoint. Does anyone know what code I can use to acually run the macro
that opens the form?

Thank you,
Lorraine