Application Turned Off

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have series of UserForms that interact with Workbook.Sheets, what is the
best / optimum method of turning off the Excel application interface so that
the only windows on display are the userforms ?
 
Nigel,
THIS will completely hide excel and show form only.

You'll have to have bulletproof code and errorhandling.
If the code within the form breaks (has stateloss) the user will not be
able to recover excel.


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


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Back
Top