I want to create a spreadsheet that users can access and make changes up to a
predetermined date and time. At that time the workbook and/or specific
worksheets lock, allowing "read only". Can this be done?

Justin
You can do this by having a Workbook_Open macro that picks up on the
date you specify and protects all the sheets with some password. But be
aware that Excel is not built as a secure platform. There are many ways
that whatever scheme you come up with can be defeated. HTH Otto
"Justin" wrote in message
...
I want to create a spreadsheet that users can access and make changes up to
a
predetermined date and time. At that time the workbook and/or specific
worksheets lock, allowing "read only". Can this be done?

In article , "Otto Moehrbach" wrote:
Justin
You can do this by having a Workbook_Open macro that picks up on the
date you specify and protects all the sheets with some password. But be
aware that Excel is not built as a secure platform. There are many ways
that whatever scheme you come up with can be defeated. HTH Otto

...as an obvious example, setting the system date to be earlier than your
'cut off date'.

"Justin" wrote in message
...
I want to create a spreadsheet that users can access and make changes up to
a
predetermined date and time. At that time the workbook and/or specific
worksheets lock, allowing "read only". Can this be done?



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)