Hi I have locked/protected a couple of cells, while simultaneously running some VBA code to hide those cells on a conditional basis.
The protected cells cannot be hidden. I have to unprotect the sheet in order to hide the cells. Please help with the same.
Also I have a cell B2, who's input affects cell B3 (protected cell). I'm not allowed to make changes to B2, it says runtime error 1004 if i do so. Please help with the same.
I'm attaching a picture of the code as well as the excel file. The fields in green are to be edited, the fields in white are to be blank.
The protected cells cannot be hidden. I have to unprotect the sheet in order to hide the cells. Please help with the same.
Also I have a cell B2, who's input affects cell B3 (protected cell). I'm not allowed to make changes to B2, it says runtime error 1004 if i do so. Please help with the same.
I'm attaching a picture of the code as well as the excel file. The fields in green are to be edited, the fields in white are to be blank.