允许用户在VBA中编辑excel表中的范围

I have a work book which has different sheets having names as user names(windows login) of different users. Now I have added a code to add new sheet to the workbook for a new user. I wanted to give permission to the same user to edit certain ranges through the code in the new sheet created. If I unlock certain cells all the users will be able to edit the ranges in this user's sheet. How I can get the 'allow users to edit ranges' functionality through vbaI have a work book which has different sheets h