How will be that permission granted every time they want to update that range?
In Excel 2010 (and if I remember well in 2007 too), you can assign a password for editing a group of cells, but when you give the users that password... how do you reinstall the protection?