Open with Openform; Workbook not visible
 

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.
--
PK

Open with Openform; Workbook not visible
 

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.
--
PK