Hi
While Doyce's answer is probably the correct one, I had the extra problem
that the clients used Excel's formulae to audit their own work, and I got a
spreadsheet with subtotals and extra columns.
I locked down the Row 1 completely - they could change nothing - they could
add extra columns, and, if they deleted essential columns I pointed this
out.
Then I locked down the important columns so that dates, for example, were
verefied as dates. I also not alone locked down cells, I set vertification
on them to be a number between -9999999 and -9999998. That way, even if the
removed the lock, they couldn't change the value!
Eoin
On 30 January 2013 14:52, dnwinberry winberry.doyce@roadsysinc.com> wrote:
> **
>
>
> John,
>
> I hope others chime in on this, but my idea would be to send the vendors a
> locked down database that they can update that contains a procedure to
> create the spreadsheet after they make the updates and emails it to your
> customer. You could use the free Access runtime so the vendors wouldn't
> have to have Access installed on their PC's.
>
> Doyce
>
> --
--
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar