Hi all
I have a wb with a selection of sheets.
What I am trying to do is write code so I can pdf a specific sheet from a front page.
My idea is you select the first sheet and then press the button for the sheet you wish to pdf. I don't want the pdf button on every sheet.
I can get vba to pdf the active sheet, but I'm struggling to pdf a non active sheet from the active sheet.
Any advice will be appreciated.
I have a wb with a selection of sheets.
What I am trying to do is write code so I can pdf a specific sheet from a front page.
My idea is you select the first sheet and then press the button for the sheet you wish to pdf. I don't want the pdf button on every sheet.
I can get vba to pdf the active sheet, but I'm struggling to pdf a non active sheet from the active sheet.
Any advice will be appreciated.