I have some worksheets in my workbook which I would like to be hidden. On these worksheets there are some NL(table…. So they will be filled with data. I have hidden these worksheets but when I press the Jet Reports Renew button the worksheets are visible again. Is it possible to keep them hidden?
Date
Votes
3 comments
-
Jet Reports Historic Posts On those worksheets that you want to hide, place Auto+Hide+Hidesheet in cell A1.
When the report is run, those sheets will be hidden.
-HP -
Jet Reports Historic Posts Great It works, Thanks.
-
Jet Reports Historic Posts You're welcome! Glad it works.
-HP
Please sign in to leave a comment.