Hide All Excel Toolbars, Menubars etc when UserForm Loads

[Shazi]

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

 

[Jim Rech]

Use the Application.Visible property.

--
Jim
|
| 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
|

 

[john]

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