LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default The same event handler for two CommandBar buttons

The same event handler for two CommandBar buttons
I add custom command

There are who similar XLA AddIns which add commandbars. The names of
commandbars are different and are formed from the name of the corresponding
xla file.
But the event handlers have the same names; it leads to the fact that
clicking on a button of any commandbar calls identical event handler. To be
exact, the handler from the file, which has been opened in the first
instance, is called.

I suppose that the same ID of the buttons causes the problem, but I failed
to add a button with my own ID.

Is there a solution for this issue?
Thank you!

Here is my code:


Option Explicit
Option Compare Text

Public strCommandBarName As String
Const strParameters = "Parameters"

Sub AddCommandBar()

Dim c As CommandBar
Dim CB As CommandBarButton
Dim cp As CommandBarPopup

On Error Resume Next

strCommandBarName = ThisWorkbook.Name
strCommandBarName = Replace(strCommandBarName, ".xla", "")

Set c = Application.CommandBars(strCommandBarName)

If Not c Is Nothing Then
Application.CommandBars(strCommandBarName).Delete
End If

Set c = Application.CommandBars.Add(strCommandBarName, msoBarTop, False,
False)

c.Enabled = True
c.Visible = True

Set CB = c.Controls.Add(msoControlButton, 1)
CB.Style = msoButtonIconAndCaption
CB.Caption = strParameters
CB.OnAction = ThisWorkbook.Name & "!" & "OnActionParameters"
CB.FaceId = 304

End Sub
Sub DeleteCommandBar()
Dim c As CommandBar
On Error Resume Next
Set c = Application.CommandBars(strCommandBarName)
If Not c Is Nothing Then
Application.CommandBars(strCommandBarName).Delete
End If
End Sub

Private Sub OnActionParameters()
MsgBox ThisWorkbook.Name
End Sub

Function GetMyIndex() As String
Dim FileName As String
FileName = ThisWorkbook.Name
FileName = Replace(FileName, ".xla", "")
GetMyIndex = Mid(FileName, Len("ReplaceOnMask") + 1)
End Function

 
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
Event handler VBA Noob[_4_] Excel Programming 4 April 26th 06 03:49 PM
Clipboard Event Handler? [email protected] Excel Programming 1 April 2nd 06 04:37 AM
Event handler is invalid Minh[_2_] Excel Programming 2 December 8th 05 02:00 AM
where is the workbook_open event handler??? Steff_DK[_10_] Excel Programming 2 April 25th 04 02:43 PM
different IDispatch in event handler Dirk[_2_] Excel Programming 0 January 23rd 04 11:04 PM


All times are GMT +1. The time now is 08:12 PM.

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"