Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Expiration Code
I've seen a couple of questions regarding password and/or macro expiration in
the community and I had an idea! Please respond to tell me what you think or to expand the following: Excel does not provide expirations for macros or password (I have my passwords all set to protect/unprotect with macros) - However: It may be a clever idea to write into the macro a certain cell reference that must match a code that the writer puts into said cell. For example I could write a mcaro that will work fine in this month's workbook because the today() hidden in a special cell matches the current month - When the month turns - the macro becomes useless because the info in the special cell on the workbook no longer matches the burrent month/year. RESULT = a sort of hidden expiration written into the macro itself. Granted, a good workbook writer could figure this out, but not just anybody! Most peole I know don't mess with macros. Can anyone think of a better way - maybe expound on this or toss in a twist? I'LL be lQQking for your replies! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expiration Formula | Excel Discussion (Misc queries) | |||
How do I set up a formula for calculating an expiration date? | Excel Worksheet Functions | |||
color code a row by expiration date? | Excel Worksheet Functions | |||
sheet with expiration dates | Excel Discussion (Misc queries) | |||
How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) |