View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Looking for a MSDN article.

I found the article fine, heading

Description of the Excel 2000 Security Patch: November 11, 2003

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Zoo" wrote in message
...
Hi all,

The code written below works well on my computer with Excel 2000 SP1.
It does not work on the same machine with Excel 2000 SP3 (Excel.exe file
version:9.0.0.6627)
It works well on the same machine with Excel 2000 SP3 sercurity
update(Excel.exe file version:9.0.0.8216).

And I'm looking for the MSDN article concerning this in order to report

the
phenomenon to my client.
In http://support.microsoft.com/kb/830349/ , there's no such article.
Does anyone know about that?

'-----This code adds a menu on the worksheet menu bar.
'And when you click [Test]-[DisplayTestMessage] ,
''OK' is displayed unless your Excel is Excel 2000 SP3 early version



Public Const sMenuBarName As String = "Test"

Sub AddMenu()

Set cstMenu = Application.CommandBars("Worksheet Menu
Bar").Controls.Add(Type:=msoControlPopup, temporary:=True)
cstMenu.Caption = sMenuBarName

With cstMenu
Set cstChildMenu = .Controls.Add(Type:=msoControlButton)
cstChildMenu.Visible = True
cstChildMenu.Caption = "DisplayTestMessage"
cstChildMenu.OnAction = "'Test ""OK""'"
End With
End Sub

Public Sub Test(ByVal sStr as String)
MsgBox(sStr)
End Sub

Sub DeleteMenu()
Application.CommandBars("Worksheet Menu

Bar").Controls(sMenuBarName).Delete
End Sub