VBA and ActiveX Licensing .. ?
 

pls find the description of how to add a.m. control to
your form.

1) open VBA project and show user form in design mode
(should be your ProjectForm in current project)
2) choose Tools|References from menu, References dialog
will show up
3) Click 'Browse' button, the 'Add Reference' dialog will
show up
4) choose file 'Comdlg32.ocx' which should be located
in ..system32 directory
5) The reference to 'Microsoft Common Dialog Control 6.0
(SP3)' should be added and marked as available
6) Display the Toolbox, move cursor to Toolbox and press
right mouse button
7) Choose 'Additional Controls' from context menu
8) Activate 'Microsoft Common Dialog Control, version 6.0'
in the list
9) Toolbox shows now a thumbnail representing the
CommonDialog
10) Drag&Drop it to your form

11) Hopefully you do not receive the same error msg as I do

The control could not be created because it is not
properly licensed

VBA and ActiveX Licensing .. ?
 

Hi Mikael

You need Visual Studio or similar to distribute that one. And
sometimes/sometimes not this prevents you from using it too.

But Excel/Windows har built-in alternatives for its function. For Open/Save
actions use VBA's GetOpenFilename and GetSaveAsFilename, no controls needed.
Excel has its own printer dialog, and the color dialog wouldn't be very
useful Excel I believe.

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

"Mikael Nordmark" skrev i melding
...
(....)
8) Activate 'Microsoft Common Dialog Control, version 6.0'
in the list
9) Toolbox shows now a thumbnail representing the
CommonDialog
10) Drag&Drop it to your form

11) Hopefully you do not receive the same error msg as I do

The control could not be created because it is not
properly licensed