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.

Attachment 299220

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

[HaHoBe]

Hi, dondonordas,

maybe just add the unprotecting of the sheet before actually starting the code and protect it after the macro?

Please Login or Register  to view this content.

Ciao,
Holger

[dondonordas]

It works!

Cheers ^_^