I have an Excel worksheet containing checkboxes that control the contents of another cell containing the formula, as well as other cells requesting user input. I need to post this worksheet on a webpage for users. The problem is when I protect the worksheet, the formulas no longer work. The checkbox cells, the formula cells, and the user input cells are unlocked. The user input cells work when protected, but the checkbox and formula cells no longer function when Protection is enabled. How do I protect the worksheet and have the formulas still work?
You may also like
I want to add Custom Sorting option with created date on category page in Magento 2. Like its label would be Newest […]
Documentation: https://docs.litespeedtech.com/lscache/litemage/crawler/ Path to: M2-crawler.sh in server /home/user/M2-crawler.sh Via SSH I run crawler in this way: cd /home/user bash M2-crawler.sh SITE-MAP-URL How […]
I’m soon going to apply for internship and i needed a portfolio for it and i was working on it for a […]
I want to make a line graph in excel, but when i select this whole table instead of first collum of numbers […]