help locking and securing a back calc sheet while allowing for clients to use the table

[jpleonardo]

so i have two sheets.
1. a qoute table that allows the costumer to put in their inputs as well as active on/off "YES" checkboxes that feed the second sheet
2. this is where all the calculations occur using the given inputs and checkboxes activation inputs.

the problem is whenever i wish to lock the backcalc sheet and hide it, when the input table is changed it does not allow anything to happen. and we wish to not allow the clients full access to an of the back end stuff. Is there a way in excel to fix this issue. Or am i missing some form of export service with a program or whatever that will allow clients to just see the table and results.

also trying to keep the format the same as created.

[Gregor y]

There are some things you can try; however your level of success is going to depend on how adept and determined your clients are.

My guess is that you're currently locking the cells on the hidden sheets which is preventing the client's selections from modifying those cells... You'll want to unlock at a minimum the cells that are bound to the checkboxes and other similar controls.

beyond that you can look into:
+ Sheet>Right-Click on name>Hide
+ Review>Protect Workbook
+ Alt+F11>VBAProject(workbookname.xlsx)>Microsoft Excel Objects>Sheet#(sheetname)>F4>Alphabetic>Visible>xlSheeetVeryHidden
+ VBAProject(workbookname.xlsx)>Right-Click>VBAProject Properties>Protection>Lock project for viewing
+ Migrate backend sheet calculations to VBA
+ Migrate VBA calculations to web api