Help with a macro

[Immortal2014]

Hi, I have a macro and I need someone to help me with

Please Login or Register  to view this content.

My problem is that this code doesn't make that I want.
Info for my sheet:
Sheet is protected with password, many cells are locked because i have formulas and i don't loose any of them.
Any time when i need copy and paste, i do it for different row but the columns are still the same.
Can code works if I just select and copy any range in sheet? Or it must have a button to work?
Thanks in advance..

[JapanDave]

Try this,

Please Login or Register  to view this content.

[Immortal2014]

Thanks JapanDave for your help. I will try it and I will come back.

[Immortal2014]

It must put your code into a commandbutton right?

[JapanDave]

No, it is on "Selection change", so when you select the range that you want to edit it unlocks the sheet. You will have to amend the code to suit the ranges you need to edit. If you don't know how to do that, post the ranges you want to edit.

[Immortal2014]

Thanks for your response. Look, as I said at the first post, the ranges are every time differents. All that is for the same sheet. Every time who want to copy and paste, columns are the same. But changes the row.
Columns K:R are unlocked, and S:V are locked.
Example,
now I want copy K635:V635 to K637:V637. Always changes the row, tomorrow I will copy K637:V637 to K644:V644.

[JapanDave]

Well then, you are going to have to sue some sort of button or toggle to do this.

Attatch to a toggle button on the sheet you want to edit.

Please Login or Register  to view this content.

[Immortal2014]

Thanks again, I ll try it.

[Immortal2014]

Thank you very much for you macro Dave! It works perfect!

[JapanDave]

No worries.