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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RoyG" wrote in message
...
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