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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel sheet, modify, print and lock
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. " wrote: 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 |
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 |