Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vying for the focus - Worksheet Vs Forms
Hi,
In my VBA program, I have attempted to load 2 modeless forms upon startup. After which, I wish to return the focus onto the worksheet named "Sheet1". The code is written as show below: " Private Sub Workbook_Open() 'Load modeless forms form1.show 0 form2.show 0 ThisWorkbook.Activate Sheet1.Activate ActiveCell.Activate End Sub " However, I was unable to do so and the focus remains at form2. What should I do to ensure that the focus will stay at the worksheet instead of the forms ? -- Regards, Adrian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On opening a worksheet move focus to a cell based on date | Excel Worksheet Functions | |||
Modeless User Form and Worksheet Focus | Excel Programming | |||
User forms & worksheet help! | Excel Programming | |||
Set focus on graphic inserted in worksheet | Excel Programming | |||
Worksheet value to user forms | Excel Programming |