Hi
assign the following code to a shortcut or button

sub show_name()
application.Dialogs(xlDialogFormulaReplace).Show
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

"TnT" schrieb im Newsbeitrag
...
hello,
I want to create a simple command button which opens the Find
window(CTRL+F) that excel provides by click event. I tried to use the
sendkeys method combaind with all the options True \ False, application
before, but none of those worked, it doesn't focused on my excel work i
guess. help!
shay.