Colour locked Cells that are protected

George1950
Copper Contributor
Sep 28, 2021
NikolinoDE

Thanks for the example file, it does exactly what I want my file to do.
I am using Excel 365 whicch is the subscription version with Window 10 Pro operating system.

My file is complicated with 20 tabs, but I only want to colour the cells in one of the tabs.
Cant understand why the format cells check box defaults back to NO Tick in it.

Thanks for your interest
George1950
"I cannot teach anybody anything" (Socrates)
- NikolinoDE
  Platinum Contributor
  Sep 28, 2021
  George1950
  
  Protect a worksheet
  To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet, where you want team members to add data in specific cells only and not be able to modify anything else. With worksheet protection, you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet.
  Important:
  Worksheet level protection is not intended as a security feature. It simply prevents users from modifying locked cells within the worksheet.
  Protecting a worksheet is not the same as protecting an Excel file or a workbook with a password. See below for more information:
  To lock your file so that other users can’t open it, see Protect an Excel file.
  To prevent users from adding, modifying, moving, copying, or hiding/unhiding sheets within a workbook, see Protect a workbook.
  To know the difference between protecting your Excel file, workbook, or a worksheet see Protection and security in Excel.
  Hope I was able to help you with this info.
  
  Thank you for your understanding and patience
  
  NikolinoDE
  Only he who knows that he is not wise is wise. (Sokrates)

Forum Discussion

Resources