Hello there,

Can anyone tell me if I can link a Command button to a row in a table? So that when rearranging the rows the command buttons move appropriately.

You see, I have a macro to insert data from the active WS to a table in Sheet.1 and what I really need is:
- To create a command button on the row of data on Sheet.1 enabling me to "go to page" where the data came from.

I have a "go to page" macro here using data from Cell A1 as reference.
However, what I need is for the [Range("A1")] part of this code below to become the Sheet.Name of the target worksheet. 

Private Sub CommandButton1_Click()
    Sheets(Range("A1").Value).Activate
End Sub