If Command in BeforePrint

[narrowgate88]

The following code is not working like I thought it would. I've got 4 named cells on a worksheet, and if any of them are blank, I don't want the user to be able to print it. What am I missing? Is it something with my Cancel = True statement?

Please Login or Register  to view this content.

[DonkeyOte]

Do you perhaps mean ?

Please Login or Register  to view this content.

If in doubt post a sample workbook...

[narrowgate88]

Your's works and is short. I also came up with this code which also works. Thanks for your help.

Please Login or Register  to view this content.