Cancel As Boolean Help

Hello everyone, I'm looking for a bit of help on this issue I've been getting when I tried to combine 2 snippets of code together. I'm really a excel newbie and have been messing around with for quite some time, I can usually find the answer online but I'm stumped on this one.

Code:

Please Login or Register  to view this content.

I get a run-time error '1004', application defined or object defined error when I try printing. What I'm using this code for is to make sure some users input something in those specified cells AND hide a few different other cells when printing (by turning the text white I guess). The 2 separate codes work just fine when I use either one separately, but when I combined (or tried to anyways) them i get an error. I know nothing about programming so I'm really stumped, I'm sure there's a IF-ELSE-THEN statement I'm not making or something like that. Any help would be greatly appreciated. Thanks again!

Edit: [Solved]

I'm so dumb. My code works just fine but I locked the cells and protected the sheet (to keep the users from making changes to these fields) and that was the problem the whole time. So now that I unlocked those cells and unprotected the sheet, the code works for both functions, to hide some cells and to prevent the user from printing without filling the required cells. So that solved that problem, but a new problem arises, is there a way this could work WITH the locked cells and protected sheet? Also, is there a way that I could hide the condition as well? I noticed that if I have a condition for one of the cells I'm trying to hide (for instance, turn the text color red if a warranty is expired) if the condition is met, the text will not hide.