Macro on cell change, manual or sort

Bonjour,
I think I am going somewhere with this. The goal of this project is to create a Command Line Repository where I will store different Unix and SQL commands for easy fetch and copy.

When I fill any (subset at the moment) of column B, a "Copy" button is automaticaly placed in the column C and when hit put the content of the adjacent cell (column B) into Windows clipboard. That, so far, is working.

What I want now is in two parts.

First, when I sort the column B the macro is NOT executed which screw the whole project. I want to be able to sort column B and still have the macro executed to put the "Copy" button where it should be?

Second, how or where should I place my code for it to be active on any sheet of the Workbook?

I have attached the current file I am working on.

Maybe without Buttons

like this you can sort Column B without influence

Please Login or Register  to view this content.

Kind regards
Leo

Ok, let say I like the idea. What if I select more than one cell. So far it is working with a selection on one cell but leads to error if I select more than one.

Ok, found a partial soluton

Please Login or Register  to view this content.

But is it possible to send to clipboard the content of a selection of more than one cell?