| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
allow user to stop macro with yes no question
I would like to "lock" a page using a macro/button that says "Submit and
Lock", but I would like to give to display a message first that says "You will not be able to make any more changes to this page. Are you sure you want to proceed?" Then I would like for the user to be able to pick "Yes" or "No" and suspend the macro if the user says "No." How would I do this using code in an Excel macro? Thanks in advance for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Time Macro User--Stop Recording Toolbar | Excel Discussion (Misc queries) | |||
| Macro using question to proceed or stop | Excel Discussion (Misc queries) | |||
| Macro stop if file in use by other user? | Excel Discussion (Misc queries) | |||
| Using macro to stop user from emailing workbook | Excel Discussion (Misc queries) | |||
| How to stop the user from seeing what's going on | Excel Programming | |||
Threaded Mode
