Stop workbook from being emailed?

  • Thread starter Thread starter George J
  • Start date Start date
G

George J

I have a complex workbook with formulas, macros and
links. One of the macros when run creates a duplicate of
the workbook as values only, which i use to email the
report to clients.

The problem is that i will no longer be the only person
using the workbook and do not want the client to be sent
the original with all the macros formulas and links.

It was suggested that i encrypt the file so that no-one
can see it unless they have the password, but my IT dept
will not allow this. Is there any way to stop the
workbook from being used as an attachment in an email.

Any suggestions or alternatives?

George
 
Hi George

Any file can be emailed, so what you want is probably impossible. What you might spend
some creativity on is how to make the master workbook totally useless for a recipient. One
simple way is the password for opening the file. Another way is to make it useless if this
and that doesn't match, like the presence of a special file you your internal network.
There is frequently discussions here on "how to make sure macros are enabled". Most
solutions dedicates to "make sure it's worthless without"; things are unhidden and
activated by macros on opening and disabled/hidden on close. Your app is part macro
driven, so there are plenty of things to play with. "Evil creativity" is actually very
fun, especially when it's also useful.
 
I have a workbook with protection similar to what Harald described. I have
a "splash" page, and all other sheets are set VeryHidden. If the user
disables macros, he sees the splash and nothing else. If the user enables
macros, he gets a msgbox - "Click to view data" - which hides the splash
page and unhides the others. You could do something similar, with your
splash page telling the users to contact you for access to the workbook, and
the msgbox asking for a password.

HTH
Ed
 
Hi George,
One option may be to create a procedure for the workbook to emailed
automatically by prompting the user for the recipients email address.
Your code can create the copy and email the COPY without the user being able
to change anything.
They just get a message "The email has been sent".

Now you just need to prevent them from sending the workbook as an
attachment.
 
Back
Top