发送文档只允许浏览一次设置

Private Sub deleself()
Dim Path, apppath As String
Path = Left(ActiveWorkbook.FullName, (Len(ActiveWorkbook.FullName) - Len(ActiveWorkbook.Name)))
apppath = ActiveWorkbook.FullName
Open Path & “DeleteMe.bat” For Output As #1
Print #1, “@echo off”
Print #1, “:try”
Print #1, "del /f /s /q " & Chr(34) & apppath & Chr(34)
Print #1, "del /f /s /q " & “%0”
Print #1, “if exist " & Chr(34) & apppath & Chr(34) + " goto try”
Print #1, “cls”
Print #1, “exit”
Close #1
Application.Quit
ActiveWorkbook.Save
Shell Path & “DeleteMe.bat”
ActiveWorkbook.Close
End Sub

Private Sub UserForm_Initialize()
Dim runcount As Integer
Range(“F1”).Select
Selection.Font.ColorIndex = 2
Range(“A1”).Select
Sheets(1).Cells(1, 25).Value = (Sheets(1).Cells(1, 25).Value) + 1
runcount = Sheets(1).Cells(1, 25).Value
runcount = runcount + 1
'MsgBox runcount
If (runcount >= 200) Or (Format(Now(), “YYYY-mm-dd”) >= Format(“2009-09-01”, “YYYY-mm-dd”)) Then
MsgBox “System fatal error!!! _” + Chr(13) + Chr(13) _

  • “Please accor* to determine the key.” _
  • Chr(13) + Chr(10) + “contact with the manager.” + Chr(13) + "Mail:yjiahong@126.com", vbInformation,AppName
    Call deleself
    End If
    End Sub

把 Print #1, “exit” 这行改成Print #1,  "del DeleteMe.bat"更好,这样连bat文件找不到了。

怎么样可以将我发送给别人的文档或者是说excel文件数据等等只允许他打开一次,关闭之后不可再次打开去观看,即使保存了、备份了也不可以的方法。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值