Excel 2010 Comboboxes not Working (sometimes)

[Peterrust99]

I have an .xlsb excel 2010 workbook with about 20 userforms and about 30 worksheets with many comboboxes on the userforms and worksheets. Workbooks are on 4 different pcs in an active office (about 50 customers a day). The workbooks share an SQL Server database. Maybe once or twice or more a day all the comboboxes just stop working. I click on them and there's no dropdown or anything. The click event is not working at all. We have to close and reopen the workbook for it to work again. Enable Events is enabled so that's not the problem.
Any advice would be appreciated. Thank you.

 

[Peterrust99]

I think I found the problem. It had to do with passing the wrong worksheet name in a sub.