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