I am a VB/AX newbie. I can record macros but that is it. Please be gentle... lol. I am a bit frustrated and have wasted a good amount of time trying to figure this out.

I have a two page workbook called 'WorkshopChecklist.xlsm'

Sheet 1 = Checklist
Sheet 2 = Printout

On Sheet 1 there is a simple list of activities, a user would check the boxes for the activities they plan to perform. This check box results in a 'yes/no' result in Column 1 of Sheet 2. (this is complete and works)

There is a specific format to the print area on Sheet 2 that needs to maintained so simply printing the 'yes' rows will not work. (formats are done and set)

The following I cannot figure out...

I need to filter the data in sheet 2 for 'yes' results, then print sheet 2.

I would like the button on Sheet 1 as I would like to protect and hide sheet 2.

Thank you in advance for your help!

-Nash