Hi I'm trying to lock a single cell without setting its cell format to keep it locked with all other cells on the worksheet unlocked and then using tools to protect the worksheet. The reason I want to do this without protecting the worksheet is because I'm using the group function on some of my rows. I have found that when a worksheet is protected even if all cell format do not have the locked box checked it will not allow me to use the ungroup because of the protection.
In short is there a way to prevent a cells content from being changed without using the cell format lock function?
In short is there a way to prevent a cells content from being changed without using the cell format lock function?