Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expiry Date for further updates into Sheet
If you're concerned about your user *intentionally* deactivating
data validation, it will be even easier for the user to deactivate a macro - set Security to High, or decline to enable macros. XL's ability to prevent users from intentionally bypassing validation, worksheet/workbook protection, etc. is about as effective as using tissue paper for a firewall. Perhaps training your user would be more productive... In article , "Trepassor" wrote: Hi, I have a wksheet where user key in daily exch rates. I want to set a expiry date such that after 31/12/03 , this wksheet will not allow any updates. ('date' is in column A) I don't want to use data validation becos my user will know how to deactivate it. Can someone provide me with such a macro? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expiry of Excel Sheet or WorkBook | Excel Worksheet Functions | |||
Highlight expiry date | Excel Discussion (Misc queries) | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
Date Expiry function | Excel Discussion (Misc queries) |