I have created a macro in excel and assigned it to a button. Now I need to ask a confirming question of the user, "do you want to ..." Then, based on the Yes or No answer, either perform the macro or cancel it.
Also, does anyone know if you need to include personal.xls into the workbook in order to get a macro to work for users opening the file on the network?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!