Code that adds new rows to a protected sheet

**anakin** · 06-08-2008, 08:30 AM

Hello,

I'm trying to write some code that adds rows at the users discretion on the press of a button, however it needs to be a protected worksheet

I can add one row exactly how I want it, then allow the 3 relative defined ranges (rag 1-3) in the new row for editing using the following code-

Please Login or Register  to view this content.

Problem is on the next press of the button the code falls over as the Title XXXX has already been used within the "Allow users to edit range" menu.

Is there a way I reference the title to a cell / add a random generated title on each press of the button? (I also need all the previously added rows to still be editable, so I have to add to the protection list already present)

Normally I can think my way out of these issues, but this one has got me...

Thanks

A

**VBA Noob** · 06-08-2008, 10:15 AM

anakin,

Welcome to the forum.

Please take a few minutes to read the forum rules below and then add the link to the other forum where you have posted this question. To understand why we ask you to do so please read the link below called "Message to cross posters"

VBA Noob