LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File security Excel encryption Trish Smith Excel Discussion (Misc queries) 0 January 18th 09 06:04 PM
Re : Security warning when saving downloaded file from Excel Options [email protected] Excel Discussion (Misc queries) 1 April 24th 07 02:47 PM
Security warning when saving downloaded file from Excel codearchitect Excel Discussion (Misc queries) 3 April 5th 07 01:37 AM
How do I use VLookup Function effectively? Kumar India Excel Worksheet Functions 2 May 18th 06 10:04 AM
Distribute calendar.ocx within an excel file ? Alan Excel Programming 2 October 21st 04 05:00 AM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"