Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down menu which you can use to select an option from. When you have selected something numbers appear in the cells below. the problem is that i want to be able to protect those cells in which the value appear, i dont want users to be able to modify these cells, but when i protected the sheet the program cannot write to the cells and therfore i get an error. is there a way around this please? Thanks all.

Bump...Help me please someone...

No bumping (and no 'please helps' - ugh) There's an Office forum y'know Diplomacy is the art of saying 'Nice doggie!'... till you can find a rock