Common Dialog & other
 

Hello you Gurus and other exell programming addicts

I've created a program under vba exell that has been working fine on my
computer for nearly a year. Now, some colleagues are starting to use this
program aswell but on some stations VBA does not recognise the
commondialog1. function altough all station ahave been configured in the
same way by our lan manager...
I've checked in the references and there is a box checked with says :

|v| MISSING:Microsoft common dialog control 6.0

where on my computer and other recognising the function it is stated

|v| Microsoft common dialog control 6.0

does anyone know a way around this problem?



Something else now :

Is there a way to avoid that the close button (top right corner X) appears
in my userforms. I've included a dedicated button in every form that closes
the form but also does other things before doing so and I want the user to
use that (and only that) button to close the form.

Hoping I've been clear enough (...probably not) I'm waiting for any
suggestion.

Greetings from Brussels,

Didier

Common Dialog & other
 

Use the queryclose event to control closing of the userform

in the computers showing the problem, go into the vbe in tools references,
and select the missing entry, then click on the browse button and try to
find the Dll.

--
Regards,
Tom Ogilvy

"Didier Poskin" wrote in message
...
Hello you Gurus and other exell programming addicts

I've created a program under vba exell that has been working fine on my
computer for nearly a year. Now, some colleagues are starting to use this
program aswell but on some stations VBA does not recognise the
commondialog1. function altough all station ahave been configured in the
same way by our lan manager...
I've checked in the references and there is a box checked with says :

|v| MISSING:Microsoft common dialog control 6.0

where on my computer and other recognising the function it is stated

|v| Microsoft common dialog control 6.0

does anyone know a way around this problem?



Something else now :

Is there a way to avoid that the close button (top right corner X) appears
in my userforms. I've included a dedicated button in every form that
closes
the form but also does other things before doing so and I want the user to
use that (and only that) button to close the form.

Hoping I've been clear enough (...probably not) I'm waiting for any
suggestion.

Greetings from Brussels,

Didier

Common Dialog & other
 

Thank you so much Tom,

Your answers are always short, straight to the point and very effective

Thanks again,

Best regards,

Didier
"Tom Ogilvy" a écrit dans le message de
...
Use the queryclose event to control closing of the userform

in the computers showing the problem, go into the vbe in tools references,
and select the missing entry, then click on the browse button and try to
find the Dll.

--
Regards,
Tom Ogilvy

"Didier Poskin" wrote in message
...
Hello you Gurus and other exell programming addicts

I've created a program under vba exell that has been working fine on my
computer for nearly a year. Now, some colleagues are starting to use
this
program aswell but on some stations VBA does not recognise the
commondialog1. function altough all station ahave been configured in
the
same way by our lan manager...
I've checked in the references and there is a box checked with says :

|v| MISSING:Microsoft common dialog control 6.0

where on my computer and other recognising the function it is stated

|v| Microsoft common dialog control 6.0

does anyone know a way around this problem?



Something else now :

Is there a way to avoid that the close button (top right corner X)
appears
in my userforms. I've included a dedicated button in every form that
closes
the form but also does other things before doing so and I want the user
to
use that (and only that) button to close the form.

Hoping I've been clear enough (...probably not) I'm waiting for any
suggestion.

Greetings from Brussels,

Didier