Insert a new Row And Replicate Data Validation And Formula From Row Above

[oblix]

Hello All,
I have a spread sheet that has protected cells.
I basically am trying to create a macro that creates a new row of data under existing data apon double clicking in cell A. Shoud not allow double click in cell in A is protected (give message "This rowl can't be dublicated"
My Data Starts in row 8
Here are my main criteria.

1) I have some cells that have :

data validation, column D​

some cells with formulas, columns A, E to Z​

I need all cells that does not have a formula to show as blank and the data validation cells to also show blank but leave the validating in cell upon creating the new row.​

2) I want the row to always be created after the row I double clicked on in cell A.
3) On Double click it should ask user if want to add row.
4) Selecting range A to Z and not whole row for copy. When creating new row it should only be range A to Z and not whole row. SHould move that range down and not cell after Z as there is another table there I dont want to break.
Thank you in advance for possible solution