So yesterday I asked about treeview as an ActiveX control straight on a worksheet. Got it going with the following code.

Private Sub set_up_start()
'clear all nodes
ActiveWorkbook.Sheets("new_page").tvMain.Nodes.Clear

'count number of items in menu
With ThisWorkbook.Sheets("menu")
row_c = 2
Do Until .Cells(row_c, 1) = "placeholder"
row_c = row_c + 1

Loop
End With
row_c = row_c - 1 
'now populate tree - first level only at moment
For branch_count = 2 To row_c
ActiveWorkbook.Sheets("new_page").tvMain.Nodes.Add Key:="item" & branch_count, Text:=ThisWorkbook.Sheets("menu").Cells(branch_count, 1).Value
           
Next branch_count

End Sub
All worked fine. Had casue to close and open the file and suddenly couldn't click into the control or do anything with it. Deleted it. Closed file, opened it, put the treeview back in with the same name. Code now does absolutely zero. Why would that be??