Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 95 dialogs normally associate a macro with buttons other than OK
and Cancel. The macro runs when the button is pressed, all is good. Except that in Excel 2007, if the *current* workbook does not have macros enabled, then the macro does not run. This is regardless of the the fact that the dialog is run from an authrorized, installed add- in. So I was hoping to be able to simply mark the button as Dismis, and then test which button was pressed from the code that executed the Show. But I cannot find any way to do that. Application.caller does not have this information. No obvious Button property. Any ideas most welcome. Anthony (There are good reasons to use Excel 95 dialogs, even today. Fonts within boxes, references etc. Besides the obvious one of not wanting to have to change a lot of code.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Toggle button - procedure works but elegance needed (xl2007) | Excel Programming | |||
addin menu button xl2007 | Excel Programming | |||
Form button crashes XL2007 | Excel Programming | |||
XL2007 - Axis Scaling Dialog problem | Charts and Charting in Excel | |||
bring up dialog box from command button? | Excel Programming |