Excel sheet with coding not working

Your best bet would be to make sure the file does not use these controls to begin with. Both are part of an external library which is no longer part of the default Windows installation. Also, you will have to make sure every computer which needs to use this Excel file will have to be updated to include both ocx files. I can see in the code that the common controls library is there because the programmeer added a date picker control to the VBA. This can be replaced with a version which does not use any external libraries, as demonstrated here: http://www.rondebruin.nl/win/addins/datepicker.htm