Print ThisWorkbook

**cralph78** · 01-28-2014, 12:48 PM

I've been using this code and it's been working fine up until today in 2003, 2007 & 2010.

I need a code to stop the worksheet (only 1 in the book) from printing if certain cells are not completed (b3:b6,e3:e5,h3,l3,n5:n6). It highlighted the cells red and a message box appears also telling the user which cells are not completed.

I added a new code to the workbook today which clears certain cells (E3:E5) if one of them is amended using their dependnat drop down boxes, so I'm wondering if that coding is causing issues with this one as they do refer to some of the same cells? Although saying that, when I take out the new coding, the "ThisWorkbook.print" issue is still occuring.

Any help or advice would be appreciated.

Thanks.

Please Login or Register  to view this content.

**arlu1201** · 02-03-2014, 05:32 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**cralph78** · 02-03-2014, 05:48 AM

Yes, it's solved. Sorry should have advised before....

See thread:

http://www.excelforum.com/excel-prog...ror-438-a.html

**arlu1201** · 02-03-2014, 05:52 AM

For future reference -

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.