Hi All
I have created an area of user input on a sheet. The user needs to be able to insert rows at valid places and need to maintain formatting/DV etc.
My approach is shown is attached sheet.
The grid represents the working area of an input area on a sheet.
A new row can only be inserted where "C" equals 0
The user can select a cell on any row
If the row is a valid row for inserting - the range C11:H11 is inserted. This is named range - "CMLineInsert".
If the row is not valid a Msg box should appear with message "ABCD"
Is it possible to set no of lines that are inserted - say min 1 - max 5
This macro should only work in named sheets - there's about 10. (not a problem if I use a button but might want key stroke to run macro)
Thanks.
I have created an area of user input on a sheet. The user needs to be able to insert rows at valid places and need to maintain formatting/DV etc.
My approach is shown is attached sheet.
The grid represents the working area of an input area on a sheet.
A new row can only be inserted where "C" equals 0
The user can select a cell on any row
If the row is a valid row for inserting - the range C11:H11 is inserted. This is named range - "CMLineInsert".
If the row is not valid a Msg box should appear with message "ABCD"
Is it possible to set no of lines that are inserted - say min 1 - max 5
This macro should only work in named sheets - there's about 10. (not a problem if I use a button but might want key stroke to run macro)
Thanks.