Vying for the focus - Worksheet Vs Forms

[Adrian]

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
?

 

[Tom Ogilvy]

Sub ShowForm()
UserForm1.Show 0
AppActivate Application.Caption
End Sub

worked for me.