Hi I posted something similar on here but got no answer and want to change it a bit https://www.mrexcel.com/board/thread...eeded.1170440/.
I have a workbook that I protect and leave a few cells unlocked so people can input data. I also have the following macro that runs when people input data,
The Issue I have is im trying to just unprotect the cells that have data in that I need to delete and then clear cells but at present its unprotecting the whole sheet.
The cells that have data in that need clearing are
C9:C11
F18
G18
B22:B33
F36
G36
B40:B47
G51
G54
G56
C59.
Workbook enclosed,
Any Ideas?
Bookmarks