Forum Discussion
Carol D'Amato
Nov 09, 2018Copper Contributor
Help with shared worksheet protection....
Hi all! Hoping I can get help with this! We have a sheet a bunch of us here share that calculates estimated shipping costs. Every time someone uses it, it saves the last weight and dimension en...
Carol D'Amato
Nov 14, 2018Copper Contributor
Thank you for responding!! If we do "read only" or password modify, will people still be able to use the sheet. It is being used for shipping calculations so there are columns where whoever needs a shipping quote can put in the weights and dimensions of the shipment and then the other columns have formulas that will generate an approx. shipping quote. Will people still be able to do this? We just want to ensure that when the spreadsheet is closed, when the next person opens, the prior user's weights and dims do not get saved causing potential overlap and thus miscalculation if they don't see the columns were already populated. Thanks again :)
Wyn Hopkins
Nov 14, 2018MVP
Hi Carol
Yes, read-only allows users to use the file but not save it
Yes, read-only allows users to use the file but not save it