Crazy Question ! (lol)

[Farah]

Hello,

You know, I browse Mrexcel a lot... really really impressed with the capabilities of the users on this board.

I know, It's a crazy question, but can we somehow edit the excel's built-in userforms ? Example: When you click on File | Open, the Userform appears, which has a text "File name".. can we edit those ? and keep it attached to a particular workbook ?


Warm Regards,
Farah

 

[royUK]

AFAIK you can't change such built in Dialogs. You could build your own UserForm to do similar operations if you wanted to.

 

[KenCriss]

Agree. You can't change built in dialogs, but you can do something like this to change the appearance of a built-in dialog

datafile = Application.GetSaveAsFilename(initfile, "ABC Text Files (*.csv), *.csv,Text Files (*.txt), *.txt,All files (*.*), *.*", , "Find or type in a filename for ABC Company data file", "Open New")

I hope that is what you are asking.

 

[royUK]

Nice idea Ken, but I interpreted it that the OP wanted to change the Open File label within the UserForm. AFAIK yo ca't d his, maybe he can adapt your suggestion

 

[Norie]

This could be possible via the Windows API, but it's probably too complicated to bother with.