Stop Print If conditon are not met

[robrobet]

Hi,

Please take a look attach workbook, I want to stop printing if F28<>F25 and b36 is empty so user fill out b36 before print. If F28=f25 and B36 is empty then no action require. I want this on active sheet because I have many sheet in workbook.

Thanks in advance for your time
RR

[Solus Rankin]

Please Login or Register  to view this content.

[JieJenn]

Here's an alternative

Please Login or Register  to view this content.

[robrobet]

Hi Solus,

Thanks For reply, But it did not solve.
I want this to haapen on active sheet because I have lots of sheet in workbook I do not want to chose the sheet name.
And other thing if f25<>f28 and b36 is empty then stop print but as soon b36 filed out then it should print, if F25=f28 and b36 is empty then it should print as well.

Thanks for your time
RR

[robrobet]

Thanks Jie,
but did not solve the way I want may be I did not explaine well. Here I try again,
If a25<>a28 and B36 is empty then stop print but if I fill b36 then it print and ignore a25<>a28
if a25=a28 and b36 is empty then print as normal no action needed.

Thanks for your time
RR

[Solus Rankin]

Please Login or Register  to view this content.

[robrobet]

Thanks a lot Solus, It works this time.