| 网站首页 | VB.Net实例分析 | .Net技术文摘 | 下载中心 | VB.Net书籍笔记 | .Net源码 | VBS脚本与组件调用 | Windows2008技术文摘 | 给我们留言 | 
最新公告:

  没有公告

您现在的位置: 乐博网 >> VB.Net实例分析 >> 其他 >> 实例分析正文
最新推荐 更多内容
VB.Net为excel设置用户密码的实例
VB.Net为excel设置用户密码的实例
作者:Ilu    来源:乐博网整理     更新时间:2009-9-23

乐博网lob.cn提示:调试环境为 vs2008 +  windows2003 / windows2008 / xp / vista
VB.Net为excel设置用户密码的实例
Public Class Sheet1
    Private MySetMenu As Office.CommandBarButton
    Private MyCancelMenu As Office.CommandBarButton
    Private Sub Sheet1_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup
        AddMenuBar()
    End Sub
    Private Sub Sheet1_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown
    End Sub
    Private missing = System.Reflection.Missing.Value
    Private Sub AddMenuBar()
        Try
            Dim MyCommandBarPopup As Office.CommandBarPopup = Nothing
            Dim MyCommandBarMenu As Office.CommandBar = _
                CType(Application.CommandBars.ActiveMenuBar, Office.CommandBar)
            Dim MyControlsCount As Integer = MyCommandBarMenu.Controls.Count
            MyCommandBarPopup = CType(MyCommandBarMenu.Controls.Add( _
                Office.MsoControlType.msoControlPopup, missing, missing, _
                MyControlsCount, True), Office.CommandBarPopup)
            If (MyCommandBarPopup IsNot Nothing) Then
                MyCommandBarPopup.Caption = "工作簿保护"
                MySetMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MySetMenu.Caption = "设置用户密码"
                MySetMenu.TooltipText = "设置当前Excel工作簿的用户密码"
                MySetMenu.FaceId = 65
                AddHandler MySetMenu.Click, AddressOf MySetMenuCommand_Click
                MyCancelMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyCancelMenu.Caption = "取消用户密码"
                MyCancelMenu.TooltipText = "取消当前Excel工作簿的用户密码"
                MyCancelMenu.FaceId = 66
                AddHandler MyCancelMenu.Click, AddressOf MyCancelMenuCommand_Click
            End If
        Catch ex As Exception
            MessageBox.Show(ex.Message, "乐博网信息提示", _
                                        MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub
    '设置用户密码  '更多.net源码和实例,来自乐博网 www.lob.cn
    Private Sub MySetMenuCommand_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean)
        Dim MyNewPassword As String = Me.Application.InputBox( _
            "请输入Excel工作簿新的用户密码:", missing, missing, missing, _
            missing, missing, missing, missing).ToString()
        Dim MyConfirmPassword As String = Me.Application.InputBox( _
            "请再次输入刚才输入的用户密码:", missing, missing, missing, _
            missing, missing, missing, missing).ToString()
        If (Not (MyNewPassword = MyConfirmPassword)) Then
            If (MessageBox.Show("刚才两次输入的用户密码不一致,是否再来一次?", _
                "乐博网信息提示", MessageBoxButtons.YesNo) = DialogResult.Yes) Then
                MySetMenuCommand_Click(Nothing, CancelDefault)
            End If
        Else
            Globals.ThisWorkbook.Password = MyNewPassword
            MessageBox.Show("已经成功设置当前Excel工作簿的用户密码!", _
                "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information)
        End If
    End Sub
   End Class

  • 上一篇:

  • 下一篇:
  • 【字体: 】【打印此文】【关闭窗口
      相关文章:(只显示最新16条)
    VB.Net数据自增的3个实例
    VB.Net在Excel工作簿中使用Chart宿主控件显示图表
    VB.Net为excel取消用户密码的实例
    VB.Net把excel导出XPS文件
    VB.Net把excel导出PDF文件的实例
    VB.Net把excel导入Access数据库
    VB.Net把excel导入文本文件的实例
    VB.Net把excel导入XML文件的实例
    VB.Net显示和隐藏Excel操作窗格的实例
    VB.Net Excel合并单元格的实例
    VB.Net输出Word和Excel报表的实例

    | 设为首页 | 加入收藏 | 联系站长 | | 友情链接 | 版权申明 |
    乐博网欢迎各种媒体转载我们的原创作品[转载请注明出处];我们鼓励更多VB.Net开发者一起加入研究与探讨;如发现文章访问错误、内容错误或版权疑问、内容有违相关法律(如涉及政治、色情、反动或散布虚假有害信息)等情况,请及时向我们举报,我们将及时纠正!
    联系邮箱:Shiny#vip.qq.com (#替换为@) QQ交流群: 40797788 [闽ICP备05014267号]