Mar 31 2022 05:31 AM
I have created this spreadsheet as a complete beginner. I have managed to apply formulas to share certain data with other sheets within the workbook.
But for the life of me, I cannot get my head around how to protect the following cells on the sheet in order to avoid staff messing up the formulas:
Cells to protect : J4, T4, X4, W8:46, X8:46, H8:46, I8:46, R8:46, S8:46, H50:52, N51:56.
The remaining cells will be left unprotected in order that staff can enter the appropriate data required.
I just cannot find a successful way of protecting the cells correctly.
Is anyone able to offer any advice? I would be extremely grateful.
Mar 31 2022 05:38 AM
By default, all cells in a worksheet are locked, but this only takes effect when you protect the worksheet.
Do the following:
Mar 31 2022 09:22 AM
SolutionThank you Hans@Hans Vogelaar
Brilliant and instant success. Very much appreciated.
Regards
Martin Wardle-Rogers
Mar 31 2022 09:22 AM
SolutionThank you Hans@Hans Vogelaar
Brilliant and instant success. Very much appreciated.
Regards
Martin Wardle-Rogers