Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
From share drive particular excel file takes long time to open AshaPadmanabhan Excel Discussion (Misc queries) 0 April 13th 10 05:18 PM
Administrative Limit was exceeded Vinod[_2_] Excel Discussion (Misc queries) 0 June 10th 08 12:12 PM
Can 409 row height be exceeded? Susan Excel Discussion (Misc queries) 4 February 5th 08 11:03 PM
Number of IF statements exceeded... gardenhead Excel Worksheet Functions 7 July 17th 06 10:04 PM
Have I exceeded nesting limit KeLee Excel Worksheet Functions 2 August 31st 05 09:21 AM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"