In Module1:
Sub Auto_Open()
Sheets("Sheet1").TextBox1.Activate
End Sub

This works in my XL97 -- doesn't need sheet select.
I wonder what could be different? Dave D-C

Dave Peterson wrote:
It worked ok in xl2003 for me.
But I don't have xl97 to test.

DZ wrote:
Thanks for your responses. It's Excel 97.

I get 'Run-time error '438' with Activate. There doesn't seem to be a way to
do this with a Controls Toolbar textbox.

Regards

DZ