I have made a programme in Excel 2000 using VBA and a number of sheets.
Indata to the programme is at some instances entered from User forms.
The User forms are activated by clicking a Command Buttons. While
trying to activate the User forms in Excel 2003, an error message
occured: "Compile error in hidden module: Sheet 15".
Changing security level to low was not enough.

I became aware of that an ActiveCGM Control was missing. After
installing the file acgm.dll, the programme was running on computers in
my house, but problems still occured on other computers.

Are there any other settings I need to change/add in Excel 2003?
And is this acgm.dll specific for specific versions of Excel?

Beste regards
Thomas

I don't have ACGM.DLL on my machine and I have 5 versions of Excel
installed. So I don't think it's part of Excel. If it's not a control you
need and if it is referenced under Tools, References (in the Visual Basic
Editor) remove that reference. On the other hand, if it is needed obviously
all users will have to install it.

--
Jim
wrote in message
ups.com...
|I have made a programme in Excel 2000 using VBA and a number of sheets.
| Indata to the programme is at some instances entered from User forms.
| The User forms are activated by clicking a Command Buttons. While
| trying to activate the User forms in Excel 2003, an error message
| occured: "Compile error in hidden module: Sheet 15".
| Changing security level to low was not enough.
|
| I became aware of that an ActiveCGM Control was missing. After
| installing the file acgm.dll, the programme was running on computers in
| my house, but problems still occured on other computers.
|
| Are there any other settings I need to change/add in Excel 2003?
| And is this acgm.dll specific for specific versions of Excel?
|
| Beste regards
| Thomas
|

Hi Jim
Thanks for your answer. I thought I needed it because I have a lot of
graphics on some sheets and userforms. But the references must have
been left overs from earlier attempts. Best Regards Thomas