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

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

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