Printing a selection from a hidden worksheet using macro

  • Hi gurus

    I am currently using a macro (button) to select a range on another sheet and print out.

    I would like to hide the sheet but still allow it to be printed - do I need to include unhiding and re-hiding the sheet as part of the print macro or is there a code that I can add to the macro (below) to enable printing of the target without unhiding the sheet?


    Thanks


    Edited once, last by royUK: add code tags ().

  • Hello,


    You could test the following


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)