PDA

View Full Version : Time limit



ahn
09-30-2011, 09:20 AM
I am using the following procedure to force users to enable macros

vbaexpress.com/kb/getarticle.php?kb_id=379

I now want to add a time limit in the spreadsheet whereby if the time limit has expired, the procedure would DELETE a specific tab, save the worksheetsheet WITHOUT confirmation and displaying the Welcome page which will have an expiry notice

Bob Phillips
09-30-2011, 10:41 AM
If they haven't enabled macros, you are stuffed, can't do any of that.

ahn
09-30-2011, 12:52 PM
Thx for the reply. The procedure I have implemented takes care of that. But once they enable macros, I want to check for the time limit and proceed accordingly.

ahn
10-01-2011, 06:22 AM
Can anyone pls help me?

I would like to enhance the macro enable procedure outlined in the following article:

vbaexpress.com/kb/getarticle.php?kb_id=379

by adding a trial time limit in my spreadsheet.

Many thanks