Have this situation: have a sheet that is protected, and a code "Worksheet_Calculate" that when an event is triggered has to insert a row on top of partcular cell - but protection doesnt allow that. Is there a way not to get rid of the protection in order to do that? Also, what if the protection has also a password???

Many thanks

BC