Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to run auto_open before user disables macros at startup
Hi guys
I have a spreadsheet to which I have added the following code in the auto_open routine: Sub auto_open() Dim mydate As Date mydate = "10-Nov-2006" If mydate < today Then MsgBox ("Project expired on " & mydate & vbCrLf & "Press OK to exit") ActiveWorkbook.Close End If End Sub The point of this is to add an expiry time to the spreadsheet such that if todaymydate then the workbook is closed and it can no longer be used. Unfortunately, if the user has macro security set to medium then they get the option of disabling the macros before running the auto_open routine...does anybody know a better way to deal with this for me please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom User Form At Startup | Excel Discussion (Misc queries) | |||
Macros disables under medium security | Excel Programming | |||
Bypassing startup macros | Excel Programming | |||
Bypassing startup macros | Excel Programming | |||
disabling Auto_Open macros | Excel Programming |