View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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