I already found  a solution, at least if someone encounters it again
they can look up this site. In the VBA editor I just clicked View and
picked the Project Explorer option. Then I clicked Sheet1 and voila
my code  appeared. I had an old backup  which had almost the same
objects but had a different code. I pasted my recent code to the
backup and then voila my previous code was working again.