Hi ExcelForum members.

I am working with a workbook that has a password protect sheet but some of the cells there are unlock so that the user may input the require data to fill in. I assign control to insert a row (e.g control + q, to insert a row for a row where a select a cell). My code bug everytime i do that if it was under a protect-sheet.

For a clear view of what i'm doing, here's my file.

Cash Receipt.xlsm

In that sheet, the user may fill-in data in column date, particulars, invoice and so forth but not in the cells under column 'account title'. The user is required only to select account number on the column 'acct no'. If the user select, the account title appear.

The password there is "dondon".

Try to run without protection and with protection and select on the cell on the column 'date' and hit 'ctrl + q'.



Please help me


Thanks in advance ExcelForum members ^_^