Cancel Button in Open File Window
 

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

Cancel Button in Open File Window
 

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.

Code:
--------------------

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

--------------------


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=376828