这里禁用了两个按钮,不会删除。当运行Alt+F11的时候会删除。 说实话,没啥多大意义。当人家打开另一个文件先开好VBE,然后再打开这个照样可以看。 Private
Sub Workbook_BeforeClose(Cancel As
Boolean) '关掉的时候设定回来 Application.OnKey "%{f11}" Application.CommandBars.FindControl(1, 1561).Enabled = True Application.CommandBars.FindControl(1, 1695).Enabled = True End
Sub
Private
Sub Workbook_Open() '拦截控件工具箱>查看代码、拦截Visual Basic>VB编辑器 Application.OnKey "%{f11}", "killme" Application.CommandBars.FindControl(1, 1561).Enabled = False Application.CommandBars.FindControl(1, 1695).Enabled = False End
Sub
Sub killme() '删除前设定回来 Application.OnKey "%{f11}" Application.CommandBars.FindControl(1, 1561).Enabled = True Application.CommandBars.FindControl(1, 1695).Enabled = True ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName Application.Quit End
Sub
|