| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form and hiding worksheets
I'm in the process of creating an App using Userforms, etc - using the
Workbook_Open to Bring up the Main Userform Menu -- the macro is also hiding all other worksheets by name, except for the one worksheet (which is blank) that can't be hidden, in the background. Is the kosher? Or, is there more that I can do to give a more professional appearance? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User form and hiding worksheets
When the form loads, make the app non-visible.
application.Visible=false and set it back to true when unloading. -- HTH Bob Phillips "Jim May" wrote in message news:vKFZe.121896$Ep.79127@lakeread02... I'm in the process of creating an App using Userforms, etc - using the Workbook_Open to Bring up the Main Userform Menu -- the macro is also hiding all other worksheets by name, except for the one worksheet (which is blank) that can't be hidden, in the background. Is the kosher? Or, is there more that I can do to give a more professional appearance? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User form and hiding worksheets
Thanks Bob,
I didn't so much as know that there was an application.visible = false option, until NOW!! Tks again, Jim "Bob Phillips" wrote in message ... When the form loads, make the app non-visible. application.Visible=false and set it back to true when unloading. -- HTH Bob Phillips "Jim May" wrote in message news:vKFZe.121896$Ep.79127@lakeread02... I'm in the process of creating an App using Userforms, etc - using the Workbook_Open to Bring up the Main Userform Menu -- the macro is also hiding all other worksheets by name, except for the one worksheet (which is blank) that can't be hidden, in the background. Is the kosher? Or, is there more that I can do to give a more professional appearance? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| one user form multiples worksheets | Excel Worksheet Functions | |||
| Hiding Worksheets and Unhiding them easily for Novice User | Excel Discussion (Misc queries) | |||
| Hiding worksheets based on user selection | Excel Worksheet Functions | |||
| User form and hiding spreadsheet | Excel Discussion (Misc queries) | |||
| Hiding worksheets based on user permissions | Excel Programming | |||
Linear Mode
