Windows 7 :Find dialog quite buggy in Excel 2007 on Windows 7

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

Hi Jaytea,
Your problem seems weird as migrating your excel file from Vista to Win 7 should have no problem.
I would bet that your file is damaged whether during edit, got some power fluctuation, or your harddisk sector which contain the file is replaced by CHKDSK during improper shutdown.

You can try open that file in another computer. I think the result would be the same. It's damaged in the file. Not because of Windows