Entry password to read/edit excel file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jackie Reynolds (jackie.Reynolds.1f2r8n_at_excelforum-nospam.com)
Date: 11/02/04


Date: Mon, 1 Nov 2004 21:36:57 -0600


Hi all,

I would like to have a script, which in the background should check the
password and open the excel file for either READ or MODIFY only mode.
When the user opens the xls file, it should pop up for password and
when entered it should trigger the activity. The user should not have a
clue as to the password given to him or her is for READ or MODIFY
access. If this can be achieved by default setting itself without
having to write script, you are most welcome to share.

IS THIS POSSIBLE IN MS-EXCEL ?

:confused:

-- 
jackie Reynolds
------------------------------------------------------------------------
jackie Reynolds's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15968
View this thread: http://www.excelforum.com/showthread.php?threadid=274423


Relevant Pages

  • Re: Modifying a record field value while not blocking it to others
    ... And of course again the record you are trying to modify has not to be 'open' ... someone opens that ID=12 record everything in it is locked. ... often add a script line which opens a random record if the file holds enough ... system where customers use Credits when renting items and get Credits ...
    (comp.databases.filemaker)
  • Re: Modifying a record field value while not blocking it to others
    ... And of course again the record you are trying to modify has not to be ... someone opens that ID=12 record everything in it is locked. ... often add a script line which opens a random record if the file holds ... system where customers use Credits when renting items and get Credits ...
    (comp.databases.filemaker)
  • Quick help on script
    ... How can I modify this script, so that it opens in a new window? ...
    (comp.lang.javascript)
  • Re: Modifying a record field value while not blocking it to others
    ... as it is effective only when you go out of the related field you just ... And of course again the record you are trying to modify has not to be 'open' ... someone opens that ID=12 record everything in it is locked. ... so the developer has to create their own work-around. ...
    (comp.databases.filemaker)
  • RE: AD-Users to contacts
    ... I've written a script that takes in input the data from a "well formatted" ... excel file that show the result of each creation. ... - Uppercase letters will be substituted whit lowercase letters ... users in formation from the old directory, the first part of the job). ...
    (microsoft.public.windows.server.scripting)