Hi,
I have multiple sheets in my workbook and within these sheets I have three checkboxes (Form Controls) that i want to create a macro that, when all three checkboxes are checked (TRUE), will print the active sheet in PDF (no security needed). When printing the PDF i want the file name to be equal to the worksheet name plus a text containing "V-" and also a certain cell value B10 (week number) for example: "DesignPlan 1234 V-6.PDF"
I would like this to be a Private Sub so each sheet is printed separately only if the three checkboxes is checked on that particular sheet
I've attached an example file...
Bookmarks