How do I do yes/no macros

[ghrek]

I not got a clue where to start here.

Im looking for a macro with button where person press YES it moves to next sheet or if they press NO I need the sheet called "CASH SHEET" and "Sheet2" printed.

Any ideas?

 

[Joe4]

You would just put a command button on your sheet, and assign a Macro to that button.

The things you want to do should be fairly simple and straightforward, and you can get a lot of that code simply by using the Macro Recorder and manually peforming the actions you want to happen.

Here is a write-up on how to assign your code to a button. I recommend using the Form Control, and not the ActiveX controls.

Assign a macro to a Form or a Control button - Microsoft Support

Create a Form button or a Command button and assign a macro that performs an action when a user clicks the button.

support.microsoft.com