Microsoft Visual Basic Compile Error: Expected End Sub

[shexe]

I am receiving Microsoft Visual Basic Compile Error: Expected End Sub on the code listed below. Can anyone please help me decipher what needs to be corrected?

Please Login or Register  to view this content.

[Pete_UK]

You should put code in code tags - see the Forum Rules.

However, your first 2 lines are:

Please Login or Register  to view this content.

and so Excel would expect an End Sub before your second line.

Hope this helps.

Pete

[Marcol]

Get rid of this line

Please Login or Register  to view this content.

And put your posted code in tags before the Mods get both the three of us ...

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[shexe]

Thank you for pointing out that code needs to be tagged.

I am still able to save the workbook without having the required cells fulfilled. Is the code I posted just prompting a message box (which I am not getting) or does it actually restrict the user from saving?

Please Login or Register  to view this content.