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.