Hi Anna B,

You need to dismiss the userform. You can click the close button in the
corner ( X ), or add this line after Sheets("SheetNameHere").Select:

Unload Me

That will close the form so you can continue working on the selected sheet.

Regards,
GS