Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Open Excel Document | Excel Discussion (Misc queries) | |||
VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it | Excel Programming | |||
open excel file but lock account | Excel Discussion (Misc queries) | |||
Unhide sheet on open only if password to modify is given | Excel Programming | |||
lock only formula cells without protecting sheet - leave open | Excel Programming |