If you want a user to select an element from a TM1 dimension from your Excel front end then you can use a SUBNM and get a user to double click the cell or....
put a transparent text box over the subnm cell and assign a macro like this
Sub Dept()
Sheets("Menu").Range("Dept").Select
Application.Run Range("[tm1.xla]tm1!ENTER")
End Sub
This allows a user to only single click to get to the subset editor.
