Is it possible to open only form when an excel file opens...

[Guest]

Hello,

I can make visible = false for every sheet in startup. But... I do not want
to see even the borders of menus etc. of the excel.. Only the form.

Or if can not, i want to see the less for excel menus...

Regards,

 

[Guest]

One way, in the form's code module:
Private Sub UserForm_Initialize()
Application.Visible = False
End Sub

Private Sub UserForm_Terminate()
Application.Visible = True
End Sub

 

[Guest]

Or in the ThisWorkbook code module:
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub

keeping somethin somewhere to make it visible again such as
Private Sub UserForm_Terminate()
Application.Visible = True
End Sub

in the form's code module.