application.onkey depending on a if function.

Something like

Please Login or Register  to view this content.

Dear Jason.b75

your code says something like " if the contents of the cell are protected, i hit a key and the selection will be deleted".

However I would like the following. When i hit the delete button and the worksheet is protected, not the workbook, there should pop up a userform asking "Are you sure you want to unlock the sheet" with a button "yes" and "no". In case you push "yes", the sheet will be unprotected. In case "no" you go back without any act.
When the sheet is unprotected, the userform shouldn t pop up and the delete button should be used for deleting the cell contents.

regards marc

Try

Workbook module

Please Login or Register  to view this content.

Standard module

Please Login or Register  to view this content.

Dear,

I have the following:

THIS WORKBOOK

Please Login or Register  to view this content.

SHEET "DATABASE"

Please Login or Register  to view this content.

SHEET "DATABASE"

Please Login or Register  to view this content.

it works good for the sheet "DataBase". But in the other sheets I want the delete key to have its normal function instead of popping up the message box. You now what to change?

with kind regards,

marc

Dear,

I have the following:

THIS WORKBOOK

Please Login or Register  to view this content.

SHEET "DATABASE"

Please Login or Register  to view this content.

SHEET "DATABASE"

Please Login or Register  to view this content.

it works good for the sheet "DataBase". But in the other sheets I want the delete key to have its normal function instead of popping up the message box. You now what to change?

with kind regards,

marc

Dear,

Thanks a lot for helping me out.

IT WORKS.

I changed the following:

THIS WORKBOOK

Please Login or Register  to view this content.

kind regards,

marc

Dear,

Thanks a lot for helping me out.

IT WORKS.

I changed the following:

THIS WORKBOOK

Please Login or Register  to view this content.

kind regards,

marc