View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrian[_7_] Adrian[_7_] is offline
external usenet poster
 
Posts: 29
Default 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