Hi everyone,
I have an excel sheet, tak combines empty cells (where different people are required to fill in some information) with forms - namely switches.
I would like to have my sheet locked, so that users can only input data, but not change formatting and formulas. The problem is that when I lock the sheet, I'm not able to change switches in the forms - it says, that the switch is locked. I have tried setting both the switch and the cell beneath it to "not lock", but it didn't have any effect.
Can you please give me some advice how to solve this issue?
I have an excel sheet, tak combines empty cells (where different people are required to fill in some information) with forms - namely switches.
I would like to have my sheet locked, so that users can only input data, but not change formatting and formulas. The problem is that when I lock the sheet, I'm not able to change switches in the forms - it says, that the switch is locked. I have tried setting both the switch and the cell beneath it to "not lock", but it didn't have any effect.
Can you please give me some advice how to solve this issue?