I guess my real point is that no matter what you do, you can't make that excel
file safe from distribution.
THE BIG O wrote:
Dave, thanks again.
The spreadsheets/files are going to be accessible via the company intranet.
We expect the people in the branch locations to hit the link on the intranet
and the file will open, they will then enter information or choose a
selection via a drop down menu to get their result. They should then close
out of the file. The set up will not allow them to do a save because they are
not the owner of the file. However, if they save to their desktop they can
do so. I am not sure if the concern about destroying something and saving is
valid but I am going to pass along all of the information to my IT dept.
Most likely they have dealt with this situation but I wanted to see if I
could set it up without taking up their time as they are busy. It now is
over my head on how to do the coding.
thanks again
Michael
"Dave Peterson" wrote:
Just some thoughts...
#1. You're going to have to add some code to the workbook_beforeclose that
actually saves the workbook with the worksheets displayed the way you want.
Sometimes it's not a good thing to save a workbook--if the user destroys
something and wants to close without saving, it could become a problem.
#3a. The project protection can be broken very quickly. Either by stuff
available for free on the web or by a commercial password breaker.
Greg Wilson wrote:
You can't prevent someone from emailing it but you can do the following to
safeguard the contents:
1. Have wb_close event code that unhides and activates a message sheet and
also hides all other sheets (xlVeryHidden). The message sheet simply displays
a message that tells users they must enable macros to use the wb. Macros must
be enabled for this to work.
2. Have wb_open event code that looks for a secret file on your company's
network or on the harddrive of authorized computers. If not found then the wb
will give a message to the effect that access is denied and then promply
close (you could also include a password override option). Macros must be
enabled for this to work.
3. If the above file is found then the wb_open code hides the message sheet
and unhides the other sheets. Therefore, the wb opens in a normal state. The
user will not see the message sheet.
Note that if the user elects not to enable macros then they will only see
the message sheet (which tells them they must enable macros to use the wb)
and all other sheets will remain hidden. If they enable macros then the above
features will work.
If someone emails the wb to an outsider then the secret file will not exist
at their location. They will not be able to use the wb if macros are enabled
or not enabled. Also note that xlVeryHidden worksheets can only be unhidden
through the VB Project. The above strategy can only (to my knowledge) be
circumvented by breaking the VB Project protection which is likely too
difficult for the candidates you refer to.
Regards,
Greg
"THE BIG O" wrote:
I have protected both sheets and workbooks and locked all of cells that need
to be. There there are drop down boxes which provides information based, on
the selection, from the hiddent sheets. Anything that shows to the user
could be seen by a customer or carrier if a branch were to intentionally or
unintentially send it to them. That is why we want do not want to allow the
files to be e-mailed.
Michael
"y_not" wrote:
Don't know that theres a way to stop someone from emailing spreadsheets
- even if you could stop them they could simply change the file
extension; email it then change the file extension back to .xls
Why not just password protect the sheets? You can hide the formulas,
lock certain cells, recolour text to white (to hide it) etc.
Is this a possibility?
--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=531978
--
Dave Peterson
--
Dave Peterson