Disable printing in Excel 2010 unless cell(s) are filled out

**toddp** · 09-21-2011, 10:06 AM

Hello

I have Excel 2010 and I am trying to disable the print funtion until certain cells (AO6, F9, AO9, BD0, etc) are filled out.

I found this code on the website, but does not work for me...

Please Login or Register  to view this content.

Is there someting i am missing?

TY

**JBeaucaire** · 09-21-2011, 10:10 AM

Hi Todd. Welcome to the forum.

As per forum rules (you can click the link in the menu bar above and read through them), please EDIT your post above, and add code tags around you posted code as demonstrated in my signature below.

Please Login or Register  to view this content.

I'll take a look at your code after that. Thanks.

**toddp** · 09-21-2011, 01:32 PM

solved with this:

Please Login or Register  to view this content.

**royUK** · 09-21-2011, 01:51 PM

Simplest way is to define a Named Range in the worksheet that is the cells to check, Then just use

Please Login or Register  to view this content.

**used2reg** · 04-13-2013, 10:48 PM

Reposting additional Question - i use the above sample i posted - is there a way to have it setup to look at worksheet. In the sample i used it seems to go across the whole workbook, not just the current sheet