I'm having trouble deploying a macro which uses the CommonDialog control.

Initially I was having trouble deploying the macro as the CommonDialog
control would only work (when placed on the worksheet) if VB was installed on
the machine.

I then read somewhere (http://www.kbalertz.com/kb_281848.aspx) that the
control could be included in a UserForm as it would then count as a run time
control rather than design time one.

This works fine on 97 but when run on a machine with 2000 (but no VB), we
get the following issue:

&H80004005 (-2147467259)

I'm thinking this may be an occurrence of this:

http://support.microsoft.com/default...b;en-us;230888

Is there another method to contain the CommonDialog control rather than
using UserForms?