Open Excel sheet, modify, print and lock

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tohle@atlas.cz - 27 Apr 2008 07:38 GMT

Hi,
I have a novice question.
I need to create XLS file, which contains some form - this sheet have
a version number (something like 1.1) which increments after Printing
procedure (explain later).
Person, who opens that file, automaticaly gets new (incremented)
version of document, can alter this document, and finaly can call
Printing procedure.
This only means, to one click, print that document twice (normal, and
with some text over screen - "SPECIMEN" for example). Something like
watermarked version.
After printing, document will be saved, as new file, which cannot be
modified - save like read only, or locked (for view only).

Is that possible in Excel?
Can it be done secure on Windows share (NTFS)? Nobody can alter files,
after printing, nobody can delete or change them.
Which commands will be needed for each mentioned action?
* for version incrementing (1.1, 1.2, 1.n)
* for printing two (visually diferent) documents by one click
* for locking and saving to new file

Thanks a LOT,
Peter

Thanks a lot for help

Reply to this Message

Joel - 27 Apr 2008 13:11 GMT

I think what you need is a templet file that is automatically opened as
read-only. Then when it save th e modified templet it puts the file
automatically in a standard directory. Before it saves the file is check to
see what the latest version of the file as sve the file at the next higher
version number. Then after it saves the file it makes the file read-only.

1) Have user open a Templete file which is read-only that contains macro.
2) Create an Workbook_BeforePrint event macro which saves the file when the
user goes to print the file. the macro can add a background to the
worksheet(s) and print a 2nd bersion of the workbook
3) You probably also want a macro Workbook_BeforeSave that make sure the
file gets save with the correct name or prevents regular saving without
printing first.

> Hi,
> I have a novice question.
[quoted text clipped - 22 lines]
>
> Thanks a lot for help

Reply to this Message