|The options within the Find dialog box in Excel impact the way .Find works within VBA and vice-versus.|
To be completely safe, you should set all off the options within VBA so that the code does exactly what you want it to do. This may change what shows in the Find dialog box the next time you use it within Excel, but the code should have priority since you don't want it to fail. You can actually reset the dialog box values by adding some code to "Find" something else with different options set and just don't do anything with whatever it Finds.
Open the VBA editor and place your cursor within the word .Find.
Press F1 to open the VBA Help file.
If you have to, expand the section entitled:
Find method as it applies to the Range object.
This will show you all of the settings you can use with the .Find method. Set them as required to have it work properly for you.
Let me know if you have any other questions.