Using macro to stop user from emailing workbook

[scooppbear]

Does anyone know of a macro in excel that can disable the emailing or sendto
option in excel. I have a workbook and I need to stop the using from being
able to send the file via email. I am hoping there is something similar to
the beforesave or beforeprint option.

Thanks!

 

[CaptainQuattro]

You can record a macro that deletes the email options from the File menu
when you open the file.

The help function includes these instructions for manually customizing
menus:

*DELETE A COMMAND FROM A MENU*

On the Tools menu, click Customize.

The Customize dialog box must remain open; however, you might need to
move it out of your way.

Click the menu that contains the command you want to delete.

Drag the command you want to delete off the menu.

Simply Record a macro while performing the above, and save it as :

-Private Sub Workbook_Open()-

If you want to restore these menu functions after users close the
workbook,
simply record a macro while dragging the deleted items from the
Customize dialog box back to the File menu, and save that macro as

-Private Sub Workbook_BeforeClose()-