Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default onAction with parameters

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

DM Unseen

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing several parameters to OnAction property. LABKHAND Excel Discussion (Misc queries) 1 April 24th 09 08:02 PM
OnAction of Menu Bar with variable parameters chris Excel Discussion (Misc queries) 1 August 7th 06 04:03 PM
Set up OnAction of a Menu Bar button to a function with variable in the parameters chris Excel Discussion (Misc queries) 0 July 17th 06 05:05 PM
passing parameters to OnAction Michel Pierron Excel Programming 8 October 29th 04 11:59 PM
Passing Parameters through OnAction Mark Bigelow Excel Programming 3 September 10th 03 12:53 AM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"