<div>
Reregistering Uniobjects did not fix the problem, but I thought that it could be that one of the other dlls that needed to be reregistered. 'Buyers' is a project that users here use to do their work. &nbsp;It accesses the back office database via uniobjects, has planning and sales functions and creates excel reports amongst others. When 'Buyers' was reinstalled, it fixed the problem.<br />
<br />
Thank you for your help and in putting me in the right direction
</div>


Reregistering Uniobjects did not fix the problem, but I thought that it could be that one of the other dlls that needed to be reregistered. 'Buyers' is a project that users here use to do their work.  It accesses the back office database via uniobjects, has planning and sales functions and creates excel reports amongst others. When 'Buyers' was reinstalled, it fixed the problem.

Thank you for your help and in putting me in the right direction

<div>
<div class="content wysiwyg-content">
I wrote an Excel VBA program for my company and it has been used for over a year by 6 users, running Windows XP and Office 2007. 4 of the 6 users now receive a 'Compile Error: &nbsp;Automation Error' when they move their cursor anywhere near (but not touching) a command button. The command button contains visual basic code that formats data on the excel sheet and retrieves data from a backoffice 'Universe' database. <br />
When the error occurs, the program goes into debug mode and displays the subroutine <br />
for the worksheet before doubleclick event.<br />
<br />
We can't understand why this is only happening for some users using the same excel workbook.<br />
<br />
Can somebody please point us in the right direction.<br />
<br />
Thank You.<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/08_w34/597752/Error-message.docx" target="_blank" class="file-inline" title="Error Message (142 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Error-message.docx</a>
</div>
</div>


Error-message.docx

I wrote an Excel VBA program for my company and it has been used for over a year by 6 users, running Windows XP and Office 2007. 4 of the 6 users now receive a 'Compile Error:  Automation Error' when they move their cursor anywhere near (but not touching) a command button. The command button contains visual basic code that formats data on the excel sheet and retrieves data from a backoffice 'Universe' database. 
When the error occurs, the program goes into debug mode and displays the subroutine 
for the worksheet before doubleclick event.

We can't understand why this is only happening for some users using the same excel workbook.

Can somebody please point us in the right direction.

Thank You.

Excel/Visual Basic Compile Error

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.