When you open a workset project and check out one workset, that workset should become the active one. It only prompts you to change the active workset when you check out a second one.