ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   onAction with parameters (https://www.excelbanter.com/excel-programming/332611-onaction-parameters.html)

Alfonso Sanz

onAction with parameters
 
I have buttons that are dynamically created at run-time with an
onAction macro that passes 1 parameter.

CMB.OnAction = "'SymbFunc """ & SymbolNr + 1 & """'"

Where SymbolNr is a counter.

When I click on the toolbutton the function is executed, for example
SYMBFUNC "4".

This works great on a lot of XP computers with Office 2000. But the same
XLA on some other computers with XP and Office 2000 does not work. The
function SYMBFUNC is just ignored. When I press on the Toolbutton
nothing happens.

The procedure Symbfunc is inside an XLA.

Does anybody have an idea, why this happens?

bye

Alfonso Sanz
Alcatel SEL AG

DM Unseen

onAction with parameters
 
Macro secuirty could be set to "HIGH" on those machines, so they will
not execute VBA (Tools-Macro-Security)

DM Unseen



All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com