| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open with Openform; Workbook not visible
Is there a way to open an Excel workbook only showing a Openform (not showing
the workbook at all)? I would like it to start with a openform asking a question; upon the response, it will open the workbook. -- PK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open with Openform; Workbook not visible
Two slightly different approaches using the ThisWorkbook module... '-- Private Sub Workbook_Open() ThisWorkbook.IsAddin = True UserForm1.Show ThisWorkbook.IsAddin = False End Sub '-- or '-- Private Sub Workbook_Open() ThisWorkbook.Windows(1).Visible = False UserForm1.Show ThisWorkbook.Windows(1).Visible = True End Sub '-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Patrick Kirk" wrote in message Is there a way to open an Excel workbook only showing a Openform (not showing the workbook at all)? I would like it to start with a openform asking a question; upon the response, it will open the workbook. -- PK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook Open but not visible (and not HIDDEN?!?) | Excel Discussion (Misc queries) | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| Temporary file open; not visible at all | Excel Programming | |||
| Hide (visible+AD0-false) all open applications? | Excel Programming | |||
| Is a visible workbook open? | Excel Programming | |||
Linear Mode
