Publish range of cells - interactive
I have a workbook with multiple sheets. Most of the sheets contain formulas and background information. The final sheet has a calculator that takes input for some variables and then displays the results of the calculations.
If I embed the entire workbook to a page on my external site I can navigate to the final tab and input data that runs the calculations. I want the interactivity, but I want to hide all of the other sheets.
If I embed a range of cells on my external site I see only those cells, but those cells are not interactive on my site. They are a read-only view of the data.
How can I either get interactivity to the range of cells or restrict access to sheets on the full work embed option?
-Bob