Button to search

ok..
but.. is it possible to run it as the sheat opens?? i mean, i open the file and the search form apears by itself??


i´m stuck in this.. it will show the toolbars with the file, edit, format,...

Sub Botão2_Clique()
'
' Botão2_Clique Macro
' Macro gravada em 17-10-2006 por OEM
'
' Atalho por teclado: Ctrl+l
'
Application.CommandBars("Chart Menu Bar").Visible = True
End Sub

Originally Posted by rmarin51

ok..
but.. is it possible to run it as the sheat opens?? i mean, i open the file and the search form apears by itself??


i´m stuck in this.. it will show the toolbars with the file, edit, format,...

Sub Botão2_Clique()
'
' Botão2_Clique Macro
' Macro gravada em 17-10-2006 por OEM
'
' Atalho por teclado: Ctrl+l
'
Application.CommandBars("Chart Menu Bar").Visible = True
End Sub

Press Alt/F11 to open the VB code window, and select ThisWorkbook

Copy the following code there.

Sub workbook_open()
SendKeys ("^f")
End Sub

hth
---

thanks mate
that was exactly what i wanted...

PROBLEM:
by itself it works but with the code to make the toolbars disapear it wont....

pic:
http://img246.imageshack.us/img246/2199/1zv1.jpg

Originally Posted by rmarin51

thanks mate
that was exactly what i wanted...

PROBLEM:
by itself it works but with the code to make the toolbars disapear it wont....

pic:
http://img246.imageshack.us/img246/2199/1zv1.jpg

you have a Sub and a Private Sub both called WorkBook_Open ?