Thread: Open with Openform; Workbook not visible
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default 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
Reply With QuoteReply With Quote