View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr.CIMS Dr.CIMS is offline
external usenet poster
 
Posts: 1
Default Excel VB - show userform1 (at same time) minimized application win

I'm creating a user guide ( of sorts) and I want nothing but the
Userform1 shown and the excel Application window not shown
at start up when I click open the file autotabs.xls
This is what I have so far....

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
UserForm1.Show
End Sub

Both won't work at the same time, is there away around this?