Thread: Cancel Button in Open File Window
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norie Norie is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote