Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShaFix a time not to be exceeded
Such as 30 days not to be exceeded Pls put into this workbook, Private Sub Workbook_Open() Application.DisplayAlerts = False aa = GetSetting(appname:="MyApp", section:="Startup", key:="aaa", Default:=1) MsgBox "Remaining" & 30 - aa & "]Times!!" If aa = 30 then ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName ThisWorkbook.Close False End If aa = aa + 1 End Sub ( Source from Excel Home ) -- 007007007 ------------------------------------------------------------------------ 007007007's Profile: http://www.excelforum.com/member.php...o&userid=29111 View this thread: http://www.excelforum.com/showthread...hreadid=498921 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From share drive particular excel file takes long time to open | Excel Discussion (Misc queries) | |||
Administrative Limit was exceeded | Excel Discussion (Misc queries) | |||
Can 409 row height be exceeded? | Excel Discussion (Misc queries) | |||
Number of IF statements exceeded... | Excel Worksheet Functions | |||
Have I exceeded nesting limit | Excel Worksheet Functions |