From: Suresh Lohar on
How a password is set in excel sheet. When double click an excel file, first
of all

you see protected and a window appeared, asking for password to open that
excel file.

I want to know how is that possible or how to make such password without
that

one even can't open the file.

Suresh

From: Gord Dibben on
File>Save As>Tools>General Options

Follow your nose from there.


Gord Dibben MS Excel MVP

On Sun, 30 May 2010 12:26:25 +0530, "Suresh Lohar" <suresh.lohar(a)gmail.com>
wrote:

>How a password is set in excel sheet. When double click an excel file, first
>of all
>
>you see protected and a window appeared, asking for password to open that
>excel file.
>
>I want to know how is that possible or how to make such password without
>that
>
>one even can't open the file.
>
>Suresh

From: JP Ronse on
Suresh,

Do you mean, save as, password to open, password to modify?

Wkr,

JP


"Suresh Lohar" <suresh.lohar(a)gmail.com> wrote in message
news:568F742B-B5DC-492D-B9CC-BA05FACDB82E(a)microsoft.com...
> How a password is set in excel sheet. When double click an excel file,
> first of all
>
> you see protected and a window appeared, asking for password to open that
> excel file.
>
> I want to know how is that possible or how to make such password without
> that
>
> one even can't open the file.
>
> Suresh