Is it to prevent a workbook from being emailed?

[Gbiwan]

Just another quickie!

Is it possible to prevent a user from sending a workbook using the "File"
"Sent to" option? (and just that workbook)

Just wondering...

Greg

 

[Harald Staff]

Hi Greg

Afaik not really. You could have a macro in the file that disables that Excel menu, but it
would still be a file on a computer, and nothing would prevent it from being sent as an
attatchment in any email. There are macro ways to ensure that the file is useless unless
this and that condition is met on opening, but it's not Safe in the real meaning of the
word.

 

[Gbiwan]

I sorta thought so...

thanks anyway!

Greg

Hi Greg

Afaik not really. You could have a macro in the file that disables that Excel menu, but it
would still be a file on a computer, and nothing would prevent it from being sent as an
attatchment in any email. There are macro ways to ensure that the file is useless unless
this and that condition is met on opening, but it's not Safe in the real meaning of the
word.