How to stop auto defaulting back to a selected sheet after using ComboBox drop-down

Hi,

I'm having a weird issue and nothing I've tried has worked... not even sure why this is happening. I'm using the following code on a sheet with a combobox drop-down that jumps to a few specific sheets in a workbook. That function works great, however for some reason once I use the drop-down and go to the selected sheet, if I go to any other sheet after (using the sheet tabs at the bottom not the drop-down) and enter data in that next sheet as soon as I hit enter it automatically takes me back to the last selected sheet from the drop-down.

So for example if I select and go to sheet "Grade1" from the drop-down, and then go to another sheet "Parents" (not using the drop-down) and enter data in a cell, as soon as I hit enter (the data is entered in the cell) it automatically takes me back to the sheet "Grade1". Is there anything I can do to the code to stop that from happening?

Please Login or Register  to view this content.