I have a ComboBox ("Model_Select") that allows the user to select the model they want to use when running a VBA macro. The selection is linked to a cell ("B17"). After the macro runs, I lock cell "B17" to prevent the user from changing the model after the code is run. This, however, does not prevent the user from editing the selection in the ComboBox. If they edit the contents of the linked ComboBox an error message stating that cell "B17" is locked from editing pops-up on the screen. That is fine, however, the content of the ComboBox changes anyway. In other words, cell "B17" and the ComboBox contents no longer match. I don't want the user to be able to edit the ComboBox selection unless they Unprotect the Worksheet. I need to be able to do this with VBA code. Note: The ComboBox is locked but it does not lock the contents.
I am running MS Office 2007 in 2003 compatibility mode.