Hi, how do I create a Find and Replace shortcut button on my Exce
Spreadsheet? Since I decided to hide the toolbars, they can't selec
EditFind...

Thanks,

Gar

--
gtto
-----------------------------------------------------------------------
gtton's Profile: http://www.excelforum.com/member.php...fo&userid=2472
View this thread: http://www.excelforum.com/showthread.php?threadid=53303

I guess you could record your own macro and use a hot key

--
Don Guillett
SalesAid Software

"gtton" wrote in message
...

Hi, how do I create a Find and Replace shortcut button on my Excel
Spreadsheet? Since I decided to hide the toolbars, they can't select
EditFind...

Thanks,

Gary


--
gtton
------------------------------------------------------------------------
gtton's Profile:
http://www.excelforum.com/member.php...o&userid=24721
View this thread: http://www.excelforum.com/showthread...hreadid=533036

Hi Gary,

Try assigning the following code to a button:

'=============
Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogFormulaReplace).Show
End Sub
'<<=============


---
Regards,
Norman



"gtton" wrote in message
...

Hi, how do I create a Find and Replace shortcut button on my Excel
Spreadsheet? Since I decided to hide the toolbars, they can't select
EditFind...

Thanks,

Gary


--
gtton
------------------------------------------------------------------------
gtton's Profile:
http://www.excelforum.com/member.php...o&userid=24721
View this thread: http://www.excelforum.com/showthread...hreadid=533036