Re: More than one password?

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

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 09:11:32 -0500

He clarified that he meant workbook, not worksheet passwords. You method is
for worksheets and then for worksheets in xl2002 and later, but he may find
it useful nonetheless. 

-- 
Regards,
Tom Ogilvy
"Sharad Naik" <sharadnaik@nospam-vsnl.net> wrote in message
news:OqdTaoY8EHA.2788@TK2MSFTNGP15.phx.gbl...
> Depends on what type of access, "YOU" need with 'so called' master
password.
>
> If access only to edit the cells is OK for you then it can work as under:
> Click on Tools Menu -> Allow User to Edit Ranges
> In the box that will appear click on 'New'.
>
> In  Refers to Cells: Filed  enter  " =1:65536 " (Without quotation marks!)
> (This refers to entire workseet range).
> Enter YOUR 'Master' password in the Range Password and click on OK.
>
> Repeat this for all sheets if you wish.
>
> Now the user can protect the sheet with his password.
>
> when you want to edit a cell, click on it, it will prompt for Edit Range
> Password,
> enter it and you can edit (change) the cell.
>
> Sharad
>
> "Tim" <Tim@discussions.microsoft.com> wrote in message
> news:3DEFD3AC-8244-44A8-B05F-BC41C1471879@microsoft.com...
> > Is it possible to protect a sheet with a master password and still let
> > someone create their own password?
> >
> > I would like to create individual workbooks for members were they can
> > create
> > their own password, yet I would still like to access them all with one
> > master
> > password. Is this possible?
>
>

Relevant Pages

  • Re: Copy Changes in one workbook to another identical Master Workb
    ... This code is supposed to be pasted into the Master file macro sheet. ... Dim wbA As Workbook ... the worksheets are Servers, Network and Storage ...
    (microsoft.public.excel.programming)
  • Re: RUSH - Need Help w/ Master Slide Background Graphics
    ... either the logos are in the background and you can't edit them. ... Also, when the logo has been inserted on the mother master, the one at the top, the logo will be copied to the other slide layouts, but you won't be able to select them there. ... can't select the graphics, it's probably inserted as a background, which ...
    (microsoft.public.powerpoint)
  • RE: Copy Changes in one workbook to another identical Master Workb
    ... I need to look at rec'd read the name in A column then go to Master find ... the Name and then update the cells that changed. ... it sure works if the files are exact except for changes but the rec'd ... I would like to have a Macro that would match column A between worksheets ...
    (microsoft.public.excel.programming)
  • Re: Great SWT Program
    ... I've explained already how this illusion works. ... They're all typically 7-bit ASCII. ... the file, edit, and rename it back, for instance. ... jack of all trades or master of one. ...
    (comp.lang.java.programmer)
  • Re: Header/footer/page number problem
    ... the Master page, if you put anything on the Master page it will be on all pages. ... Everything looks fine -- until I decided to add headers. ... when I try to follow these instructions: "In the Edit Master Pages ...
    (microsoft.public.publisher)