Forum Discussion

Anthony Smith's avatar
Anthony Smith
Brass Contributor
Aug 16, 2018

Cell is Not Recognized as Filled If Filled Using VBA

I have a cell that is highlighted yellow if a checkbox is checked. I want to restrict printing if this cell is still highlighted, but my macro is not working. My code to highlight (fill) the cell b...
Excel
Macros and VBA
  • Haytham Amairah's avatar
    Haytham Amairah
    Aug 17, 2018

    Please make sure that the Workbook_BeforePrint Sub is in ThisWorkbook code module as the below screenshot.

     

     

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Aug 17, 2018

Hi Anthony,

 

I've tested this code but it works!

Please tell me what the error type you got?

  • Anthony Smith's avatar
    Anthony Smith
    Brass Contributor
    Aug 17, 2018
    The issue I'm having is that I'm still able to print.
    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Aug 17, 2018

      Please make sure that the Workbook_BeforePrint Sub is in ThisWorkbook code module as the below screenshot.

       

       

      • Anthony Smith's avatar
        Anthony Smith
        Brass Contributor
        Aug 17, 2018

        Ah yes, that seemed to be the issue. Thanks!

Resources