I have created a form button that allows me to click on it to take me to
another worksheet within that workbook. But, it only seems to work when I
have it in Design Mode. Once I save my worksheet and come back to it, it does
not work unless I put it on design mode. Is there a reason why?

(I created the button from the forms toolbar and added a hyperlink to it to
take me to a different worksheet)