| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vista Office 2003 File Open Window @details will only show file n. | Excel Discussion (Misc queries) | |||
| open mht file - on all the window | Charts and Charting in Excel | |||
| open file in different window | Excel Discussion (Misc queries) | |||
| How check for No/Cancel Button when SaveAs and file already exists? | Excel Programming | |||
| How do open each excel file in its own window | Excel Discussion (Misc queries) | |||
Hybrid Mode
