View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rémi Rémi is offline
external usenet poster
 
Posts: 2
Default Security discussion - how to effectively distribute an Excel file

Hello!
I would enjoy input into how people effectively distribute an Excel
file to clients, that they can use without too much trouble.

Here's my situation:

I have an Excel file I've coded some macros for. I will be delivering
it to my client tomorrow, for their review. They run Excel 2003, and I
would like to set something up that they can use without too much
hassle. Mainly, I would like to avoid having to reduce their security
settings to use the file.

Problem is, the file is a timesheet. Each user makes a copy of it, and
then enters time information into it. My understanding of digital
signatures has it that as soon as a user saves the file (with their
entered time data), the digital signature will be removed, since I am
no longer the only person to have worked on the file. And (I believe)
that afterwards, they will be getting the security prompt once again,
'till the end of time.

How is this type of situation dealt with? Obviously, a time sheet is
not useful as a read-only file; users *have* to enter data and save it.

How do the gurus deal with this type of situation?

Regards,
Remi.