bug on the macro coded sheet, a protected sheet, every time i made an action i wanted

[dondonordas]

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 ^_^

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

I will close this thread, your other thread seems to have a valid attachment

Thread Closed.
http://www.excelforum.com/excel-new-...-i-wanted.html