VBA warning to print 1 page

[excellence]

I have a 2 page spreadsheet that I would like to warn me, prior to printing to print 1 page as I need to take the printed page and flip it to print page 2

I tried the vba below, but I can't get past the warning to print page 1 as the message keeps coming back.
Perhaps there is a different way but wonder how to edit this to answer no and proceed to the print dialog box so I can choose which page to print, not both.

My guess is to have the cancel=true modified to take me to the print dialog box?

Many thanks

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Result = MsgBox("PRINT 1 PAGE  ANSWER >>> NO", vbYesNo)
    If Result = vbNo Then
        Cancel = True
    End If
End Sub

 

[excellence]

Insert and run VBA macros in Excel - step-by-step guide

This is a short step-by-step tutorial for beginners showing how to add VBA code (Visual Basic for Applications code) to your Excel workbook and run this macro to solve your spreadsheet tasks.

www.ablebits.com

since my last post I have done, I believe what the guide says, but can't get it to run automatically when I choose PRINT.
I can run the macro macro>run but it doesn't automatically run.
I have created a new module and pasted your vba into it.

Guess I am still missing something
Will continue to see what I am missing
Thanks

 

[jolivanes]

I guess you better wait for someone else. After 20 posts, you still refuse to tell us step by step what you want to achieve.

Good Luck

 

[Jaafar Tribak]

Want to be reminded to select one page when printing if I print. May want to print preview the spreadsheet and not print it when I see the preview, but was reminded about just printing one page if I decide to print.

Is this the Print Preview you are refering to?

 

[excellence]

Is this the Print Preview you are refering to?

View attachment 111695

I fixed it with a message box when selecting Print to issue my warning. Thanks