Protected sheet how do I allow row insertion on specific rows

[ArnolddG]

Hi,
I have a protected sheet:

Please Login or Register  to view this content.

I only want to have the user insert a row in a row/range with unprotected cells.
With above code it is AllowInsertingRows:=True or False (all or nothing)
How would I do this ?

Thanks for helping,
Arnold

[ArnolddG]

Please ignore this double post. I got a Server Error while posting but apparently it was posted afterall. (Can I delete this myself ?)

[ragulduy]

I'm not sure there is an easy way to do this. The only thing I can think of would be to set allowinsertingrows to true but then create an event for "before insert row" and use code to only allow this to happen if the cells are unprotected.

Unfortunately excel does not have a "beforeinsert" event so you need to use a set-up similar to the one in this thread:
http://www.mrexcel.com/forum/excel-q...row-event.html

[ArnolddG]

Hello yudlugar,
Thanks for your help.
I will be looking into your suggestions this evening...