move to next cell

[excellence]

Hi,
It's been a while and apologize in advance if I am not obeying the rules, but haven't done vba or macros for a while and never was any good at it but here goes:
I am looking to be able to automate the following:
I have a protected worksheet where the involved cells are g3:k8 where I would like to have the 1st active cell as g3 and offset 1 cell at a time to g8.
It would then go to g4:g8...then to g5 same thing,g6 same,g7 and g8 same. For what it's worth, I have some data validation in each cell, which would limit the user to enter just 1 character. So, if e.g GG was entered and dialog box would come up to tell user only 1 character allowed and user could retry to meet the 1 character limit.

If you choose to rsvp, please be real basic, as I am in preschool with this. Also, on a Mac using the latest office

 

[rollis13]

All you have to do is to paste the script in Sheet1's module (before or under any other macro if already there). Then, when you move from Sheet1 to Sheet2 and back, you will find in Sheet1 the cursor in cell G3.
If you have no reason to move to Sheet2 and back but would be okay to go to cell G3 when opening the file you could use this other script to be pasted in ThisWorkbook module:

Private Sub Workbook_Open()
    Worksheets("Sheet1").Select
    Range("G3").Select
End Sub

elsewise please attach an example of your file.