| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform always visible
I have a Userform setup to open automatically when my file is opened. I'd
like to dock it in the upper right-hand corner and have it visible at all times. Right now, the user must close the Userform to make adjustments to the workbook, or change move from sheet to sheet. Is it possible to leave the Userform visible without interferring with the workbook activity? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform always visible
If you are using Excel 2000 or later, you can show the form
modelessly. E.g., Userform1.Show vbModeless -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "StephanieH" wrote in message ... I have a Userform setup to open automatically when my file is opened. I'd like to dock it in the upper right-hand corner and have it visible at all times. Right now, the user must close the Userform to make adjustments to the workbook, or change move from sheet to sheet. Is it possible to leave the Userform visible without interferring with the workbook activity? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform always visible
Hi StephanieH,
StephanieH wrote: I have a Userform setup to open automatically when my file is opened. I'd like to dock it in the upper right-hand corner and have it visible at all times. Right now, the user must close the Userform to make adjustments to the workbook, or change move from sheet to sheet. Is it possible to leave the Userform visible without interferring with the workbook activity? Yes, depending on the version of Excel you're using. Try this: frmMyUserform.Show vbModeless This will allow VBA execution to continue (in versions Excel 2000 and newer), and it will allow the user to continue interacting with Excel as needed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform always visible
Yay. Worked perfectly. Thanks Chip.
"Chip Pearson" wrote: If you are using Excel 2000 or later, you can show the form modelessly. E.g., Userform1.Show vbModeless -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "StephanieH" wrote in message ... I have a Userform setup to open automatically when my file is opened. I'd like to dock it in the upper right-hand corner and have it visible at all times. Right now, the user must close the Userform to make adjustments to the workbook, or change move from sheet to sheet. Is it possible to leave the Userform visible without interferring with the workbook activity? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
| Shapes, Userform and Visible | Excel Programming | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
| UserForm: Jump to the next visible cell | Excel Programming | |||
| Keep userform visible, but return control to calling routine | Excel Programming | |||
Linear Mode
