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
|