Open with Openform; Workbook not visible

[Patrick Kirk]

Is there a way to open an Excel workbook only showing a Openform (not showing
the workbook at all)? I would like it to start with a openform asking a
question; upon the response, it will open the workbook.

 

[Jim Cone]

Two slightly different approaches using the ThisWorkbook module...
'--
Private Sub Workbook_Open()
ThisWorkbook.IsAddin = True
UserForm1.Show
ThisWorkbook.IsAddin = False
End Sub
'--
or
'--
Private Sub Workbook_Open()
ThisWorkbook.Windows(1).Visible = False
UserForm1.Show
ThisWorkbook.Windows(1).Visible = True
End Sub
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



(Excel Add-ins / Excel Programming)
"Patrick Kirk"
wrote in message
Is there a way to open an Excel workbook only showing a Openform (not showing
the workbook at all)? I would like it to start with a openform asking a
question; upon the response, it will open the workbook.