Use PDF.

There is no way that you can really protect a workbook from
modification as long as the user has access to it. Macros can be
bypassed simply by holding down the shift key when opening the file.

Worksheet and Workbook protection are designed to keep people from
inadvertently changing data. There are free add-ins and macros (see

http://www.mcgimpsey.com/excel/removepwords.html

for one approach) available.

There are techniques you can use to make it more difficult (e.g.,
setting all but one sheet's .Visible property to xlVeryHidden and
putting "You must enable macros" on the remaining sheet, then using
the Workbook_Open event macro to unhide), but in general, they're
still for fooling really naive users, not those with, say, the
wherewithal to find these newsgroups.



In article ,
(Michael I) wrote:

Hello all,
I work for a clinical research company. We are working toward
regulatory compliance with the FDA, and this includes electronic
records. At the current moment, we have system in place that exports
data to an excel spreadsheet from an old DOS based program. The
problem is that someone could theoretically change the data on the
spreadsheet, comprising the integrity and validity of the data and the
clinical trial. I need to make a system which does not allow users to
change the information on the spreadsheet.

I was thinking that a macro would work for something like this,
but I don't have much experience programming macros.

If anyone could point me in the right direction, I'd be grateful.

Thank you very much,
Mike