Forum Discussion
Colour locked Cells that are protected
If you want to protect the sheet,
go to - Extras --> Protection --> Protect sheet
-- if you select this, the "Protect sheet" window opens.
You can assign a password at the top and in the box below
define what users can and cannot do.
Put a checkmark in front of "Format cells".
Now you can format the cells despite password protection.
I would be happy to know if I could help.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Hi NikolinoDE
Thanks for your reply.
Have done exactly what you suggested and it works, while I stay on that tab.
But when go to another tab amd come back to the tab I want to colour the cells it defaults back to there being no tick in the 'Format Cells' checkbox. The same thing happens when I close the file and reopen it again.
Best Regards,
George1950
- It would be an advantage if you could see the file (without sensitive data) to see where the error could be.Knowing the Excel version and the operating system would also be also an advantage.Here is an example file with a locked sheet where you can change the color.
Thank you for your patience and time.
NikolinoDE
I know I don't know anything (Socrates)
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)
