VBA - Popup message when user selects a Protected Cell

Hi All,

I searched on the forum and found a previous post that matched my situation.

I'm trying to created a MsgBox with a message when a user tries to edit a protected cell in a workbook (I don't want the default message that Excel produces when you edit a protected cell).

I've used the following code from a previous post, but can't seem to get it to work:

Please Login or Register  to view this content.

Anyone any suggestions?

Scott - I have placed this in the Sheet code ad not in a module. I have code in the same sheet for button click actions so this is the sheet code isn't it?

coreytroy - I specifically want a user-defined message as opposed to just protecting the worksheet and having the default Excel pop-up.

Apologies all - by some strange wonder - I've gone into my spreadsheet this morning and it's working just fine

Modified it slightly - specifying the locked cell range as opposed to the user-editable range - and also adding in an action to Undo and put the formula back:

Please Login or Register  to view this content.