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.
Bookmarks