One technique I've used in the past is to use VBA to open a text file in Binary mode. With this, you can read the passwords for comparisons.
This password file is then placed on the network and cannot be opened/viewed
by anyone UNLESS THEY WRITE A VBA MACRO.
Of course, you have to protect your VBA project so that it cannot be
reverse-engineered.
But if they cannot see your code, and you avoid calling your password file
something obvious:
("Do not Read - This is a password file.txt" wouldn't do very well)
The likelihood of someone making use of it is REDUCED.
Paul
-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
________________________________
From: dguillett1 <dguille...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 9:28:53 AM
Subject: Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end
users
All I had to do was unhide the sheet..... and the code was not protected
(easily
defeated)
. Even if you had hidden with xlVERYHIDDEN code could unhide.
Although more trouble, you may want to use separate protected workbooks where
security is higher for most users.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Krishnaraddi V. Madolli
Sent: Wednesday, September 12, 2012 8:08 AM
To: excel-macros@googlegroups.com
Cc: Subramani P N
Subject: RE: $$Excel-Macros$$ Excel sheet wise restrictions required for end
users
Hi Pravin,
Please find the attached document prepared as per your requirement. Column B
will give password for each sheet.
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-30540000 Extn 1915
Email: krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com| The leader in innovative claims and productivity
management solutions
Success is never permanent, Failure is never final, so always do not stop
effort
until your victory makes a history.
Please consider the environment before printing this message
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Pravin Gunjal
Sent: 09/12/2012 14:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel sheet wise restrictions required for end users
Dear Masters,
In the attached file there are six working sheets in it.
The concerned person will send a mail of this file to his down level for their
working/use.
Sheet 1 is made for the master (which can be seen to all end users). While
others - sheet 2 to sheet 7 (i.e. ASM to SO5) are created for individual
details.
I have used a hyperlink to go to the sub sheets.
>From ASM to SO5 working sheets : the end users are individuals and one should
not see the others data (it should be password protected or any other
restriction may be given).
For an example : If I am a SO4 user then when I click on SO4 button in the
sheet1 before following the link the system should ask a password to open the
SO4 sheet. Otherwise it can be restricted for use.
Please help me out on this issue. If you require any other information from me
please write to me. Thanks a lot !
With regards,
Pravin Gunjal
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
<<image001.png>>
