Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform always on top?
Hello, Is there a way to make a userform be always on top? I have a userfor that is constantly being used, and with there being no icon in th taskbar, I have to switch screens around constantly. Is there a way t set up the userform so it is always on top? If not, is there a way t create a taskbar icon similiar to excel -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=26800 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform always on top?
In the View menu, Toolbars, Customize, I selected the
Tools category, then at the bottom of the Commands list, I dragged and dropped the Custom icon out to the main menu. Still in the Customize dialog box, I clicked on the Modify Selection button, assigned the ShowUserForm macro to the new menu item. Finally, I added a module and created the following procedu Sub ShowUserForm() UserForm1.Show End Sub Hope that gets you started. Geof. -----Original Message----- Hello, Is there a way to make a userform be always on top? I have a userform that is constantly being used, and with there being no icon in the taskbar, I have to switch screens around constantly. Is there a way to set up the userform so it is always on top? If not, is there a way to create a taskbar icon similiar to excel? -- dok112 --------------------------------------------------------- --------------- dok112's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10581 View this thread: http://www.excelforum.com/showthread...hreadid=268004 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform | Excel Discussion (Misc queries) | |||
Userform Rev | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Concerning Userform | Excel Programming | |||
Userform inside another userform | Excel Programming |