vb代码,供参考: Dim objMyControl As Object Dim i As Integer
' 获得word的 Application 对象. Set mApp = Application '添加工具栏 Set mBar = mApp.CommandBars '去掉所有菜单 For i = 1 To mBar.Count - 1 If mBar.Item(i).Visible And mBar.Item(i).Name <> "Menu Bar" Then mBar.Item(i).Visible = False mBar.Item(i).Protection = msoBarNoCustomize And msoBarNoChangeVisible And msoBarNoMove And msoBarNoResize End If Next Set mMenuBar = mBar.Add("SaveAddin", , True, True) mMenuBar.Visible = True mMenuBar.Protection = msoBarNoCustomize And msoBarNoChangeVisible And msoBarNoMove And msoBarNoResize '添加主菜单 Set objMyControl = mMenuBar.Controls.Add(msoControlPopup, , , , True) objMyControl.Caption = "文件(&F)"
用word录制宏看一下,参照着写
难你能用WORD的打印功能来打印EXCEL文档吗
Dim i As Integer
' 获得word的 Application 对象.
Set mApp = Application '添加工具栏
Set mBar = mApp.CommandBars
'去掉所有菜单
For i = 1 To mBar.Count - 1
If mBar.Item(i).Visible And mBar.Item(i).Name <> "Menu Bar" Then
mBar.Item(i).Visible = False
mBar.Item(i).Protection = msoBarNoCustomize And msoBarNoChangeVisible And msoBarNoMove And msoBarNoResize
End If
Next Set mMenuBar = mBar.Add("SaveAddin", , True, True)
mMenuBar.Visible = True
mMenuBar.Protection = msoBarNoCustomize And msoBarNoChangeVisible And msoBarNoMove And msoBarNoResize
'添加主菜单
Set objMyControl = mMenuBar.Controls.Add(msoControlPopup, , , , True)
objMyControl.Caption = "文件(&F)"
' 添加菜单项
Set Bt_SavetoLocal = objMyControl.Controls.Add(Type:=msoControlButton, Temporary:=True)
Bt_SavetoLocal.Caption = "保存到本地(&L)"
Bt_SavetoLocal.Enabled = True
Set Bt_SavetoDB = objMyControl.Controls.Add(Type:=msoControlButton, Temporary:=True)
Bt_SavetoDB.Caption = "保存到数据库(&D)"
Bt_SavetoDB.Enabled = True
Set Bt_Exit = objMyControl.Controls.Add(Type:=msoControlButton, Temporary:=True)
Bt_Exit.Caption = "退出(&E)"
Bt_Exit.Enabled = True