onAction with parameters

  • Thread starter Thread starter Alfonso Sanz
  • Start date Start date
A

Alfonso Sanz

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
 
Macro secuirty could be set to "HIGH" on those machines, so they will
not execute VBA (Tools->Macro->Security)

DM Unseen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing Parameter with OnAction 3
.OnAction points to wrong file.module.procedure 1
Automation error with XLA addin, fails on commandbarbutton onaction 0
How to call user defined function (UDF) from custom menu in Excel2003? 3
Using Shape's OnAction property in C# 0
Passing several parameters to OnAction property. 1
Buttons, onAction and Parameter 3
onAction events on NewMenu 6

Back
Top