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 |
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 |
All times are GMT +1. The time now is 04:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com