| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Yes' 'No' button on autoopen macro
I have an autoopen MsgBox macro created. Instead of the "OK" button, I want the user to choose between "Yes" and "No" buttons. Yes=a pathway to a designated network drive and folder, No=remain on current worksheet. Q1. Syntax to instruct Excel to include Yes and No buttons in the MsgBox prompt. Q2. Syntax to instruct Excel what to do when either button is clicked. Thank you for any help you may offer. Your expertise is greatly appreciated
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting 'Yes' or 'No' | Excel Discussion (Misc queries) | |||
| How to do: If 'yes', then show extra columns | Excel Discussion (Misc queries) | |||
| How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
| Creating 'yes' or 'no' option in a designated cell | Excel Programming | |||
| Disable AutoOpen macro's | Excel Programming | |||
Threaded Mode
