| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Form, Hide all Sheets
I have heard that an open workbook must have at least one
sheet visible, so I was wondering if it would be possible to have an Excel file open so that only a UserForm is visible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show Form, Hide all Sheets
application.Visible = False
Userform1.Show -- Regards, Tom Ogilvy "John Pierce" wrote in message m... I have heard that an open workbook must have at least one sheet visible, so I was wondering if it would be possible to have an Excel file open so that only a UserForm is visible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show Form, Hide all Sheets
Hi,
Yep, i think so. In the when you show the form, use ActiveWindow.Visible = False or refer the wind another way etc. Good Luck Ross. (John Pierce) wrote in message om... I have heard that an open workbook must have at least one sheet visible, so I was wondering if it would be possible to have an Excel file open so that only a UserForm is visible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show zero value but hide NA | Charts and Charting in Excel | |||
| show hide row if | Excel Discussion (Misc queries) | |||
| how to hide a form button in a worksheet | Excel Discussion (Misc queries) | |||
| Form wont hide | Excel Programming | |||
| Hide and show | Excel Programming | |||
Linear Mode
