LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Open Excel Document Sonya Excel Discussion (Misc queries) 0 March 17th 08 02:50 PM
VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it MaxGruven Excel Programming 0 February 28th 08 08:46 PM
open excel file but lock account David Excel Discussion (Misc queries) 1 November 22nd 07 11:33 AM
Unhide sheet on open only if password to modify is given Alex Excel Programming 1 March 13th 07 03:52 PM
lock only formula cells without protecting sheet - leave open BLANK JUNK MAIL RECEIVED - CREATE RULE Excel Programming 0 May 12th 06 03:53 AM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"