Hi,

I have a form that is called from "Sheet1" with a button on it. When the user clicks the button, a function is called, the form is unloaded and "Sheet2" is selected.
However, while "Sheet2" does get selected, "Sheet1" is also still selected, resulting in any new changes happening to both sheets.

For example:
Private Sub CommandButton_Click()
'call function()
    Unload Me
    Sheets("Sheet2").Select
End Sub
After this is run from "Sheet1", "Sheet2" is selected correctly. However, if I type something in cell A1 in "Sheet2", it also appears in cell A1 in "Sheet1", unless I manually deselect "Sheet1".

I assume I'm doing something stupid but I've tried lots of different things with no success and have also searched for answers. From what I can tell .select should ensure only one worksheet is selected.

Thanks,
Kris