Rather than try & hide everything (which will anoy most users) have you
considered turning your application into an AddIn?
Have a look at this site if you need guidance to do this:
http://www.vbaexpress.com/forum/showthread.php?t=10855
--
jb
"Shazi" wrote:
Dear All,
I am making VBA application for store inventory, I made 7 UserForms,
for Data Entry and to view information from the worksheets.
When my any UserForm is loads, the specific worksheet related to
userform is also visible behind the userform.
I want to In-Visible every thing behind the UserForm, I mean I want to
see only UserForm nothing else. how it possible.
Pls send me your suggessions.
Regards.
Syed Shahzad Zafar