How to insert copied Rows in a protected Worksheet at a particular Place ?

[VJyani]

Hello everyone !!

It is my first post and I must say that it is a great forum with lot of useful information.

I am working on a spreasheet which is password protected. It has two section one is protected other is open.

Users are allowed to insert rows in protected area however they cannot copy and insert due to protection. So I have worked and developed a macro which allows them to do so. The only question I have is how to allow them to insert the copied cell to where ever they want.

Ideally I would like them to highlight a row and it insert the copied row there or may be input the row number (like Row 24) below which to insert the copied Row.

I have the below code at the moment to copy and insert and it only insert in the next blank row. I am new to VB and I think the below code can also be improved a bit.

Thanks for any help/suggestion.

Please Login or Register  to view this content.

[VJyani]

Any Suggestions please?

[stnkynts]

Please Login or Register  to view this content.