I have this line of code which used to "pause" a running routine, display the find dialog, and continue on with the routine when I closed it:

If Application.Dialogs(xlDialogFormulaFind).Show Then

On Windows Vista, Excel 2007 this ran as expected. However, since I've upgraded to Windows 7 and re-installed Excel 2007, the dialog that is popped up has changed. It no longer has the "Within" option which I need, if I guessed I would say it has reverted back to the older style find dialog. When I end the routine and try to pop up the find dialog via ctrl+f or the button on the ribbon, nothing happens. I have to restart excel to see it again.

Ctrl+f normally pops up the correct dialog, so I have no idea why my line of code doesn't. If I try to use SendKeys "^f" it doesn't pause the routine (which is behaviour that might seem unorthodox but is easiest for me, as a beginner).

Thanks in advance for any advice you could offer.

-jt