打开Setcbar=Comma" />

VBA访问word菜单

系统 1635 0

 

Sub  SetCommandbar()
            
'
         '  SetCommandbar Macro
         '  宏在 2007-2-1 由 创建
         '
         ' 菜单
         ' 菜单
         Dim  cbar   As  CommandBarButton

                      
' 菜单>新建
         Set  cbar  =  CommandBars( " File " ).Controls( " 新建(&N) " )
            cbar.Enabled 
=   False
                               cbar.OnAction 
=   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 菜单>打开
         Set  cbar  =  CommandBars( " File " ).Controls( " 打开(&O) " )
            cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 菜单>保存
         Set  cbar  =  CommandBars( " File " ).Controls( " 保存(&S) " )
            cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 菜单>另存为
         Set  cbar  =  CommandBars( " File " ).Controls( " 另存为(&A) " )
            cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 命令>新建
         Set  cbar  =  CommandBars( " Standard " ).Controls( 1 )
            cbar.Visible 
=   True
                               cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 命令>打开
         Set  cbar  =  CommandBars( " Standard " ).Controls( " 打开(&O) " )
            cbar.Visible 
=   True
                               cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset
         ' 命令>保存
         Set  cbar  =  CommandBars( " Standard " ).Controls( " 保存(&S) " )
            cbar.Visible 
=   True
                               cbar.Enabled 
=   False   '
        cbar.OnAction  =   " NullMethod "
        cbar.ShortcutText 
=   ""
        
' cbar.Reset


        
' CommandBars("Standard").Controls(1).ShortcutText = ""



        
' 快捷键Ctrl+N 和Ctrl+O
         ' Set cbar = CommandBars.ActionControl
         Set  myControl  =  Application.CommandBars.FindControl _
                                                                (Type:
= msoControlPopup, Visible: = True )



        
End Sub

            
Private   Sub  NullMethod()

                            
End Sub

                                
Sub  myreset()
                                    
' 菜单
         Dim  cbar   As  CommandBarButton

                      
' 菜单>新建
         Set  cbar  =  CommandBars( " File " ).Controls( " 新建(&N) " )
            cbar.Reset
                
' 菜单>打开
         Set  cbar  =  CommandBars( " File " ).Controls( " 打开(&O) " )
            cbar.Reset
                
' 菜单>保存
         Set  cbar  =  CommandBars( " File " ).Controls( " 保存(&S) " )
            cbar.Reset
                
' 菜单>另存为
         Set  cbar  =  CommandBars( " File " ).Controls( " 另存为(&A) " )
            cbar.Reset
                
' 命令>新建
         Set  cbar  =  CommandBars( " Standard " ).Controls( 1 )
            cbar.Reset
                
' 命令>打开
         Set  cbar  =  CommandBars( " Standard " ).Controls( " 打开(&O) " )
            cbar.Reset
                
' 命令>保存
         Set  cbar  =  CommandBars( " Standard " ).Controls( " 保存(&S) " )
            cbar.Reset
                
End Sub
                        
Sub  aaa()

                                
'  aaa Macro
         '  宏在 2007-2-2 由 张文璋 创建
         '

        
End Sub

VBA访问word菜单


更多文章、技术交流、商务合作、联系博主

微信扫码或搜索:z360901061

微信扫一扫加我为好友

QQ号联系: 360901061

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描下面二维码支持博主2元、5元、10元、20元等您想捐的金额吧,狠狠点击下面给点支持吧,站长非常感激您!手机微信长按不能支付解决办法:请将微信支付二维码保存到相册,切换到微信,然后点击微信右上角扫一扫功能,选择支付二维码完成支付。

【本文对您有帮助就好】

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描上面二维码支持博主2元、5元、10元、自定义金额等您想捐的金额吧,站长会非常 感谢您的哦!!!

发表我的评论
最新评论 总共0条评论