hello,

I have a 30 page excel file which I have spend over a 100 hours working on. I finally have it where I want it but the comboboxes seem to be acting up. I have the same combobox across 15 sheets. I have some code which activates sheets based on the sheet&number selected inside the combobox. this works great. the problem is that when I switch to another sheet with the same combobox the combobox sometimes has the wrong value entered.

I also was having a problem with the sheets bleeding onto another sheet but it would go away one I selected some cells and dragged through. I added a active all cells code to help with this issue.

I have removed most of the information from my test sheet so it should only really have the 14 tabs and the combobox2 which is the one with the issue.
test file.xlsm