Sorry, when asking for an example, I meant a spreadsheet and not a picture of oneAlso, please use the upload file option that is available when you press "Go Advanced" instead of linking to another location.
BTW, if the error is happening when you enter a value into a single cell in column A - then there must be something wrong with the .protect() part (because the IF would be bypassed as the target.column would evaluate to 1).
Why do you need to protect via a macro, when the macro did not unlock anything? Seems strange - I would suggest removing that line
Bookmarks