How do I return To Cell A1 after clicking a button?

Question

I have a button at the bottom of my excel sheet that generates another sheet ounce clicked. That function works fine but I need to return to the top of the sheet after I click the button and not to the new Sheet.

What kind of VBA code will be used to do this?

Answer 1

Try this sample ..

Application.GoTo ActiveSheet.Range("A1"),True