Prompting a User

[DGB]

I am not even sure if what I would like to have is possible.....

I have a workbook with multiple pages, two of which are labled "Summary" and "Questionnaire" On the Summary sheet, I would like to have a button or permanent dialouge box that asks the user if he wants to print the "Questionnaire" sheet. The button should have 2 options YES and NO. If they say Yes, change the contents of cell A2 on the Questionnaire page to "1". If they selct NO, make contents of A2 on the Questionnaire sheet to "0"

I have a macro that reads the contents of A2 on all sheets and prints if >o

Thanks

 

[VoG]

Make sure that events are enabled: in the code window press CTRL + G to open the Immediate Window, type in

Application.EnableEvents = True

and press Enter.