The built-in dialog xlDialogColorPalette requires an argument, which is
stated in the help file simply as "file_text". I suspect it is the file name
of a palette file, but I am not sure. Moreover, I have not been able to
locate a *.pal file on my HDD, so simply trying is not an option. When the
argument is omitted, the "show" method does notr lead to the dialog being
displayed.

Any ideas? Thanks in advance.

Arne

This seems to work...
Application.Dialogs(xlDialogColorPalette).Show ActiveWorkbook.Path
However, it will not return the "selected" color.
It is used only to modify the color palette in the workbook.

John Walkenbach has a custom color picker dialog available for download here...
http://www.j-walk.com/ss/excel/tips/tip49.htm

--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - Special Sort can sort by color)





"Arne"
wrote in message
The built-in dialog xlDialogColorPalette requires an argument, which is
stated in the help file simply as "file_text". I suspect it is the file name
of a palette file, but I am not sure. Moreover, I have not been able to
locate a *.pal file on my HDD, so simply trying is not an option. When the
argument is omitted, the "show" method does notr lead to the dialog being
displayed.

Any ideas? Thanks in advance.

Arne