Userforms in Excel 2003 created in Excel 2000
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 |
All times are GMT +1. The time now is 03:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com