Add rows Automatically

[kanwalno1]

Hi All,

I am after a small piece of code which can accomplish the following.

In a worksheet, column A to K are formatted as follows :

Column A : Date
Column B : General
Column C : General (Contains Validation)
Column D : Amount
Column E : General (Contains Validation)
Column F : Amount (Contains Formula)
Column G : Amount (Contains Formula) - Hidden
Column H : Amount (Contains Formula) - Hidden
Column I : Amount (Contains Formula)
Column J : General (Contains Validation)
Column K : Text

I need to protect the sheet without telling anyone the password. Only
the unprotected cells can be filled in by the user. To keep the file
size small, only 100 empty rows are to be kept at the bottom with all
the above formatting. But whenever the user consume these rows,
additional rows need to be added at the bottom, which had to be done
manually. What I require is a macro, which when executed opens up a
box asking for number of rows to be added at the bottom, and then adds
the rows, copying everything from above (but without having the need
to unprotect the worksheet).

Is that Possible ?

Regards
Kanwaljit Singh Dhunna