Button to search

[rmarin51]

hi all
i have a worksheat working as telephone list to be viewed by several computers in lan...

i have all toolbars disapering on opening of file...

my question:
is it possible to place a button that opens the built-in search function (the one in edit tab)??? or is it possible to make some stuff that searches the worksheat for a name???

i need this because many users using the TAB edit-find its already to dificult

can some one help......
thanks

[Bryan Hessey]

hi all
i have a worksheat working as telephone list to be viewed by several computers in lan...

i have all toolbars disapering on opening of file...

my question:
is it possible to place a button that opens the built-in search function (the one in edit tab)??? or is it possible to make some stuff that searches the worksheat for a name???

i need this because many users using the TAB edit-find its already to dificult

can some one help......
thanks

CTRL/F ?

---

[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

[Bryan Hessey]

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.

Please Login or Register  to view this content.

hth
---

[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

[Bryan Hessey]

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 ?

[rmarin51]

fixed lol

i´m so noob.... i just pasted the code in my existing workbook_open()
lol

thank you for all