Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent users to use a workbook/sheet after a specified day
Can someone help me with this?
I have a Workbook containing som macro, formula, and vba code and now I need prevent users to use/edit a workbook/sheet after a specified day, since there are some values that must be updated. Best regard and thank you at advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent users to use a workbook/sheet after a specified day
You can't prevent use after a specified day - there are a number of
schemes that you can try, but most of them require VBA which can be easily bypassed. You can google these groups for expiration dates to see some solutions that make it a bit more difficult for people to bypass the protection. If you're just concerned with data being out of date, you may be better off putting a disclaimer in the sheet saying that the information is only valid through your end date. In article , kelpie wrote: Can someone help me with this? I have a Workbook containing som macro, formula, and vba code and now I need prevent users to use/edit a workbook/sheet after a specified day, since there are some values that must be updated. Best regard and thank you at advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent users to use a workbook/sheet after a specified day
Thank You for your answer.
First of all, I am not wooried of user who bypass VBA , they understud why they dont dont shuold use the workbook after a specified day. Its "newbies" people i am afraid about and i will stop to use. If you have a VBA solution i am interested of this "JE McGimpsey" wrote: You can't prevent use after a specified day - there are a number of schemes that you can try, but most of them require VBA which can be easily bypassed. You can google these groups for expiration dates to see some solutions that make it a bit more difficult for people to bypass the protection. If you're just concerned with data being out of date, you may be better off putting a disclaimer in the sheet saying that the information is only valid through your end date. In article , kelpie wrote: Can someone help me with this? I have a Workbook containing som macro, formula, and vba code and now I need prevent users to use/edit a workbook/sheet after a specified day, since there are some values that must be updated. Best regard and thank you at advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Users from unsharing a workbook | Excel Worksheet Functions | |||
Prevent wandering users | Excel Discussion (Misc queries) | |||
Prevent users from copying worksheets | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) |