Assistance please. password on opening excel file

[mangchik]

I wish to do the following:

a. The excel file can only be opened with a username and password.
b. Based on the username and pasword, the file can either be opened with certain with all columns opened or certain columns hidden. Tq in adv,

Mangchik

[Tom Ogilvy]

If this is at all important, Excel just isn't the application to provide this
type of security. If you wish to allow a user to open the file, plan on them
having access to all information in that file. If you want access such as
you describe, use a centralized database that provides security at the
individual record level.

--
Regards,
Tom Ogilvy


"mangchik" wrote:

>
> I wish to do the following:
>
> a. The excel file can only be opened with a username and password.
> b. Based on the username and pasword, the file can either be opened
> with certain with all columns opened or certain columns hidden. Tq in
> adv,
>
> Mangchik
>
>
> --
> mangchik
> ------------------------------------------------------------------------
> mangchik's Profile: http://www.excelforum.com/member.php...o&userid=35993
> View this thread: http://www.excelforum.com/showthread...hreadid=558870
>
>