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


  • 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 "Like" icon ...just below...in the bottom right corner...:)