|As far as I know, you cannot set the options you want directly via VBA.|
I've heard rumors that you can do it with SendKeys, but the SendKeys method is known to be troublesome.
I tried this to set the SearchIn option to Workbook and it was terribly intermittent. Certainly not something I would roll out in a production environment.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.