Cancel Button in Open File Window

[SS]

Hi

Is there a way to deactivate the "Cancel" button in an "Open File" window?

I want to force the user to find a file. I don't want to let them get out
of it by cancelling.

Any thoughts?

Thanks!

SS

[Norie]

The only way I think you could disable the button would be via the Windows API.

Why not just check to see if they have hit the cancel button and if they have reopen the window.

Do
    x = Application.GetOpenFilename
Loop Until Application.WorksheetFunction.IsText(x)