Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
Hi,
Is there the capability to lock down Excel to the point that one could not e-mail it to another person. I have created over 1/2 dozen tools for branches to use but our concern is that they may e-mail them to a customer or carrier ( a very bad thing). Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
Nope.
Maybe the usual threats would work??? THE BIG O wrote: Hi, Is there the capability to lock down Excel to the point that one could not e-mail it to another person. I have created over 1/2 dozen tools for branches to use but our concern is that they may e-mail them to a customer or carrier ( a very bad thing). Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
This sounds like something that I probably can get our IT dept to write up
for me. Thank you Greg for your assistance. Michael "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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing someone from e-mailing an Excel spreadsheet?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |