J
JonF
Apologies if this has been covered a million times before ... I'm
moderately proficient in VBA, but I have little experience with
programming Excel.
A company wants to set up Excel sheets that can be used to calculate
lab results with various VBA range and validity checks. That's pretty
straightforward. They want the information to be protected to form an
audit trail (they are working with some stuff in which the goveernment
is very interested, and they are audited regularly by various
agencies).
They would like to set up some system whereby the workbook can't be
opened or altered or something if the user disables macros. They want
to so something like locking the entire wiorksheet and unlocking the
appropriate portions with an autorun macro, which would therefore leave
the entire worksheet locked if the autorun macro doesn't run because
macros are disabled.
Comercial third-party solutions can be considered.
Any thoughts?
moderately proficient in VBA, but I have little experience with
programming Excel.
A company wants to set up Excel sheets that can be used to calculate
lab results with various VBA range and validity checks. That's pretty
straightforward. They want the information to be protected to form an
audit trail (they are working with some stuff in which the goveernment
is very interested, and they are audited regularly by various
agencies).
They would like to set up some system whereby the workbook can't be
opened or altered or something if the user disables macros. They want
to so something like locking the entire wiorksheet and unlocking the
appropriate portions with an autorun macro, which would therefore leave
the entire worksheet locked if the autorun macro doesn't run because
macros are disabled.
Comercial third-party solutions can be considered.
Any thoughts?