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

Use the Application.Visible property.

--
Jim
"Shazi" wrote in message
...
|
| 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
|

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