View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
 
Posts: 88
Default Button on Userform calling GetOpenFilename

Hello,

Situation:
Userform with Button, Button_Click Procedure contains "Application.GetOpenFilename".
When I have done my file selection the GetOpenFilename dialog
will be closed and I see the calling Userform.
Now the Userform seems to be not modal, I can select cells,
sheets, but I can't enter values in the cells.

Question:
How can I avoid this behaviour, I'd like to have a modal userform as it is declared.
Thanks

Best Regards
Werner