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 ?





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

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


"Nigel" wrote:

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 ?





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==---- http://www.newsfeed.com The #1 Newsgroup Service in the
World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers
- Total Privacy via Encryption =---