(Msg. 1) Posted: Wed Aug 27, 2008 9:38 am
Post subject: Create Secure Data (need employee ID & password to access) Archived from groups: microsoft>public>excel>misc (more info?)
I want to create one file of sensitive data that I can send to multiple
people. Each recipient would enter their employee number and password to
access the data. If someone has done something like this in Excel, please
let me know how it was accomplished.
(Msg. 2) Posted: Wed Aug 27, 2008 11:04 am
Post subject: RE: Create Secure Data (need employee ID & password to access) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The method I use when creating password protection for data sheets is this.
Keep in mind it involves programming with VBA
But VBA has a tool called xlveryhidden
This allows you to hide sheets with out the possibility of someone unhiding
them through the normal method of unhiding sheets
Then I create and store the passwords in a module using a select case
statement.
I then create a user form that is set up like a password box and gets
triggered when the excel file is opened.
If the username and password matches then the xlveryhidden sheets are
unhidden and they can view the data. Once they close excel an event triggers
all the sheets to return to an veryhidden state.
If you add a password protection to viewing the code in Visual Basics Editor
it is basically impenetrable by regular excel users.
"Kimba" wrote:
> I want to create one file of sensitive data that I can send to multiple
> people. Each recipient would enter their employee number and password to
> access the data. If someone has done something like this in Excel, please
> let me know how it was accomplished.
(Msg. 3) Posted: Wed Aug 27, 2008 1:46 pm
Post subject: Re: Create Secure Data (need employee ID & password to access) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Excel internal security is very weak.
Any method of protection you put on can be cracked.
The general advice is................if you don't want someone to see it,
don't include it.
Gord Dibben MS Excel MVP
On Wed, 27 Aug 2008 09:38:05 -0700, Kimba <Kimba.TakeThisOut@discussions.microsoft.com>
wrote:
>I want to create one file of sensitive data that I can send to multiple
>people. Each recipient would enter their employee number and password to
>access the data. If someone has done something like this in Excel, please
>let me know how it was accomplished.
(Msg. 4) Posted: Wed Aug 27, 2008 3:00 pm
Post subject: RE: Create Secure Data (need employee ID & password to access) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
thanks for the response. will your method work if i want to segregate the
data? in other words, when a 'director' enters the correct employee number
and password, only the data that belongs to his department becomes visible.
"akphidelt" wrote:
> The method I use when creating password protection for data sheets is this.
>
> Keep in mind it involves programming with VBA
>
> But VBA has a tool called xlveryhidden
> This allows you to hide sheets with out the possibility of someone unhiding
> them through the normal method of unhiding sheets
>
> Then I create and store the passwords in a module using a select case
> statement.
>
> I then create a user form that is set up like a password box and gets
> triggered when the excel file is opened.
>
> If the username and password matches then the xlveryhidden sheets are
> unhidden and they can view the data. Once they close excel an event triggers
> all the sheets to return to an veryhidden state.
>
> If you add a password protection to viewing the code in Visual Basics Editor
> it is basically impenetrable by regular excel users.
>
> "Kimba" wrote:
>
> > I want to create one file of sensitive data that I can send to multiple
> > people. Each recipient would enter their employee number and password to
> > access the data. If someone has done something like this in Excel, please
> > let me know how it was accomplished.
(Msg. 5) Posted: Thu Aug 28, 2008 3:03 am
Post subject: RE: Create Secure Data (need employee ID & password to access) [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In article <7BE22AFC-2C7E-4664-939E-5E61B216E32E RemoveThis @microsoft.com>, =?Utf-8?B?YWtwaGlkZWx0?= <akphidelt RemoveThis @discussions.microsoft.com> wrote:
>The method I use when creating password protection for data sheets is this.
>
>Keep in mind it involves programming with VBA
>
>But VBA has a tool called xlveryhidden
>This allows you to hide sheets with out the possibility of someone unhiding
>them through the normal method of unhiding sheets
>
>Then I create and store the passwords in a module using a select case
>statement.
>
>I then create a user form that is set up like a password box and gets
>triggered when the excel file is opened.
>
>If the username and password matches then the xlveryhidden sheets are
>unhidden and they can view the data. Once they close excel an event triggers
>all the sheets to return to an veryhidden state.
>
>If you add a password protection to viewing the code in Visual Basics Editor
>it is basically impenetrable by regular excel users.
Note, however, that it is not impenetrable.
There are many password removers out there. If it is truly sensitive
data (like employment data for example), then don't send it out.
>"Kimba" wrote:
>
>> I want to create one file of sensitive data that I can send to multiple
>> people. Each recipient would enter their employee number and password to
>> access the data. If someone has done something like this in Excel, please
>> let me know how it was accomplished.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office