View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default Worksheet button question

Application.Visible = False in the workbook open event will hide the
xl app including the worksheet with your buttons. The userform will
remain visible.

In the ThisWorkbook object:

Private Sub Workbook_Open()
Application.Visible = False
UserForm.Show
End Sub