View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tohle@atlas.cz is offline
external usenet poster
 
Posts: 1
Default Open Excel sheet, modify, print and lock

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