Hi Clement

In short; don't do it. For common dialog's Open and Save, use VBA's own
GetOpenFilename and GetSaveAsFilename. The color dialog is of little use in
Excel, and Excel/Windows has their built-in printer dialogs. For a hopefully
working "Save" solution, see my reply to Sayed in this thread.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Clement" skrev i melding
...
Hi all,

I trying to add a commondialog control into my VBA form in excel, but it
show an error message "The control could not be created because it is not
properly licensed."

How to solve this problem?

Thanks

Clement