Userforms in Excel 2003 created in Excel 2000

T

taj

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
 
J

Jim Rech

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
|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
|
 
T

taj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 1
Excel 2003 Formula Error 2
Formatting changes on different comps, Excel 2000 3
Cannot run Macro created in 2003 4
Close Workbook in Excel 3
VBA project created in Excel 2003 doesn't run in Excel 2000 3
excel 2003 - excel 2007 1
loading excel takes ages 3

Top