[thelist] OT- Vis. Basic (Excel) question

[Roger H.]

Sorry for such an off topic question, but its late, and google hates me.

I have a fairly simple Excel workbook with 5 worksheets in it.
Does anyone know why:

Private Sub OnSheetActivate()
Range("B5").Select
End Sub

won't put the focus to the B5 cell, upon going to the specified worksheet?

Again sorry. I should be fed to the wolves.

-Roger Harness

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005