Embedded Google Sheet with popdown access

[browj2]

Hi,

I have an embedded Google Sheet with multiple sheets. On the second Sheet (Price History) is a dropdown list to select an item to be displayed in the chart. The problem is that users do not have access to the dropdown (or any of the cells).

Is there a way to give access to the dropdown to users? Is there another solution?

The popdown list is linked to a column on the first sheet (actually a sorted list on the third sheet)

Link to test site



Thanks,
John CB