I need help.
I am not sure this can be done.
On my password protected worksheet I have a toggle button which allows me to hide / un hide rows. Everything works perfectly.
I have another button which generates a PDF from the same worksheet. Everything works perfectly.
The same worksheet has many page breaks. One per section. When all my rows are not hidden, everything works perfectly. The PDF generated is exactly what I need. The layout is perfect and well balanced.
What I hate is when I hide rows and generate the PDF, I still get the same page breaks. I would like to find a way to disable / ignore the page breaks when I convert my worksheet to a PDF via a macro so I have everything on 1-3 pages instead of 10-11 pages. I don't want to remove the page breaks. I just don't want them to be considered when the PDF is generated. The goal is to reduce the number of pages (after activating the toggle button to hide many rows) in this precise scenario.
Is there a solution to this?
Thanks x 1,000,000.