Macro and row protection

[RoyG]

I need my macro to return me to col A in the current row no matter what
column I am in. I have tried this with "Home" but when I run the Macro a
second time from another row, I return to col A in the row above the row I
was in when I ran the Macro the first time.

Secondly, I need to prevent changes to selected rows in my spreadsheet.

Any help is appreciated

 

[Don Guillett]

Methinks that your code could probably stand some tweaking. Why not post it
here.