0
I created an Excel workbook with a large amount of data on two different worksheets. I have a 3rd worksheet that I'm using to display a clean summary of the data based on User Input. I protected the entire workbook except for 10 cells, so that my formulas are not deleted. I'm using Excel 2013.
Is it possible to have the "clean summary" worksheet automatically resize only the 10 rows and 17 columns that appear based on User Input results?
There is Allow all users of this worksheet to list when you try to protect Worksheet. https://support.office.com/en-us/article/Protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6
– Lee – 2019-07-30T08:24:49.003