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-
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
Bookmarks