I have the same problem but even after giving the user authentication I am not able to insert rows or column after protecting partuclar cells. I have Excel 2007, can you please help me