Excel

Hello Tom,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding setting up a workbook that always opens at the first sheet and the active cell is A1, and when a user clicks on any tab then the active cell will always be A1.

This requires some VBA code which must be applied to the workbook for the former requirement and to each worksheet for the latter requirement. If you later add a new worksheet you will need to copy and paste the code from one of the other sheets to the new one.

The code for the Workbook is as follows:

Private Sub Workbook_Open()
Worksheets(1).Select
Range("A1").Select

End Sub

The code for each Worksheet is as follows:

Private Sub Worksheet_Activate()

Range("A1").Select

End Sub

I have attached a file containing five worksheets with the code installed. You can use this as a test before adding the code to your own workbook/worksheets.

I hope this is what you wanted. Please note that the sheets have not been protected in any way. If you want to do this then use the Review ribbon and apply Protect Sheet option.

Give this a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer