Macro and row protection
 

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

Macro and row protection
 

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