More than one visual basic code

[123456]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sorry to keep making threads, but where do I put these two pieces of code so that they run smoothly alongside each other. The first code is so that only blank cells can be edited.

[VBA Noob]

Just a thought, Why don't you make the cell protect as a deactivate event

Please Login or Register  to view this content.

VBA Noob

[123456]

Could someone give me a step-by-step on what to click and so on, because I'm not at all sure how to use visual basic. The worksheet_deactivate doesn't appear to be working.