VB code for manual entry in range of cells

kt - Sep 3, 2016 at 07:03 PM

In my work sheets the values in some of the cells in range are determined through formula. When someone wants to change the value manually Pop should appear with message that "values cannot be modified". Please help with VB code for the same. I do not want to do this through Protect sheet concept as the functionality of Grouping and UnGrouping cells wont work.