Display error message when inserting record on a locked cell

[BMD4]

Hello All,

I have an excel which has a Insert macro to insert blank records in the selected row.

Eg: At B11, I should give 2 to insert 2 blank records.

This is working fine as expected. Now, I need to lock the Amount column in the sheet. When I lock it and run the macro. It throws an error.

It is because, we cannot insert blank row on a sheet which has a column locked.

Can anyone please suggest if I can display a message as ' Unlock the Amount' instead of the error in the file. This will help users to understand the reason of the error.

Attached a sample file of the functionality. 'test' is the password to unlock the column.

Any suggestions are much appreciated.

Thanks in advance.

[AlphaFrog]

Your macro could unprotect the sheet, insert the rows, then re-protect the sheet.

Please Login or Register  to view this content.

[BMD4]

Thank you for the reply.

My requirement is not to unprotect the sheet and insert. Rather it should inform users to unprotect the sheet.

I have updated my excel, with another macro 'Update'.

The sheet gets unprotected when clicking on 'Update' macro and I am able to insert record.

But, what is happening is I still get message as 'Select update to insert records' which is the error message displayed and then records are getting inserted.

When the sheet is unprotected, I need to have records inserted directly without the message displayed. Attaching the sheet.

[AlphaFrog]

Please Login or Register  to view this content.

[BMD4]

Thanks so much!! That works.