All,

Thank you for the comments. I did take Jean-Yves advice and it works very
well.

As for the licencing, well it makes sense but is it sense? All I am trying
to do is to create some time-saving tools using Excel 97 (as I cannot be
sure what version of Excel the recipients will be using) and so getting a
developer version for 97 could be difficult.

Anyway, thanks again

Russell

"Keith Willshaw" wrote in message
...

"David Fixemer" wrote in message
...
Mr. Russell Plummer

Jean-Yves has GREAT advise, and I would strongly
recommend using it. However, I can expand upon your
common dialog box problem a little further.

My understanding is that companies such as Microsoft
have developed a wide variety of user interface tools in
the form of *.dll and *.ocx files. When these companies
develop applications utilizing the tools, they need
anyone/everyone to be able to use them. This is done
by "registering" them on a machine, which anyone/everyone
can do for free and your machine probably has. However,
they did want to get paid for their time/effort in
developing the tools, so they charge the
developer/designer a "licensing" fee. In other words, you
have to pay to use them in a new design, however, once
designed, anyone can use them for free.

This licensing privliage can be obtained by
purchasing a developer edition of Excel (no idea of cost).


Gettingthe developer edition of Excel is not the only route, the
same controls are licensed in the development
environment with VB6.

Keith