Advertisement
burssen

Default VBA Userform - Hide This Workbook/Application

Nov 2nd, 2017
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. https://www.mrexcel.com/forum/excel-questions/561770-hide-excel-only-show-userform.html
  2.  
  3. Private Sub UserForm_Initialize()
  4. Application.Visible = False
  5. End Sub
  6.  
  7. Private Sub UserForm_Terminate()
  8. Application.Visible = True
  9. End Sub
  10.  
  11. https://www.mrexcel.com/forum/excel-questions/899439-vba-userform-hide-workbook-application-but-nothing-else.html
  12.  
  13. Private Sub Workbook_Open()
  14. ThisWorkbook.Windows(1).Visible = False
  15. If Workbooks.Count = 1 Then
  16. Application.Visible = false
  17. End If
  18.  ufrmCasesToMandate.Show
  19. Application.Visible = True
  20.  End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement