View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Hide All Excel Toolbars, Menubars etc when UserForm Loads

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
|