workbook_open事件练习:限制excel文件使用次数

南仁海杨

偷看

hot

<p>学习</p>

HYY514

<p>还是使用注册表好点</p><p>Sub auto_open()<br/>Dim n As Integer<br/>n = GetSetting("myapp", "myse", "mykey", 0)<br/>n = n + 1<br/>SaveSetting "myapp", "myse", "mykey", n<br/>If n &lt;= 3 Then<br/>&nbsp;MsgBox "工作表只能使用3次,你已使用" &amp; n &amp; "次"<br/>Else<br/>&nbsp;MsgBox "使用次数已满,工作簿关闭!"<br/>&nbsp;ThisWorkbook.Close False<br/>End If<br/>End Sub</p>

Sesshaumaru

不错！一定要看看！！

tcqun01

很实用啊

YZBPWT

[em01]

leex04

[em01][em01][em01][em01][em01][em01]

slyrabbit

<p>好提议</p>

covsan

<p>学习。。。</p>

qjls

<p>看一看</p>