| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Place a User Form on Start Up
Hello again, Firstly, thanks for the guys who helped on my last problem. Now, here's my next! I have a user form (UserForm1) that I need to have automatically open when the spreadsheet is opened (it controls unhiding various worksheets). Can anyone suggest what I need to do for this to happen? TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=552614 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Place a User Form on Start Up
In the OPEN event of the workbook put
userform1.show that should do it! SamuelT wrote: Hello again, Firstly, thanks for the guys who helped on my last problem. Now, here's my next! I have a user form (UserForm1) that I need to have automatically open when the spreadsheet is opened (it controls unhiding various worksheets). Can anyone suggest what I need to do for this to happen? TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=552614 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Place a User Form on Start Up
Hi Samuel,
Try: '============= Private Sub Workbook_Open() UserForm1.Show End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. --- Regards, Norman "SamuelT" wrote in message ... Hello again, Firstly, thanks for the guys who helped on my last problem. Now, here's my next! I have a user form (UserForm1) that I need to have automatically open when the spreadsheet is opened (it controls unhiding various worksheets). Can anyone suggest what I need to do for this to happen? TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=552614 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User form with looping doesn't start at right place. | Excel Programming | |||
| I want to set up a form in excel where I can place a jpeg or pic. | Excel Discussion (Misc queries) | |||
| How to auto place start/stop characters in Excel w/barcode fonts? | Excel Discussion (Misc queries) | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
![SamuelT[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
