disabling send as attachment

[Guest]

Is there a way to disable the option to send a workbook
as an attachment? If so, how do you do it?

 

[Ron de Bruin]

Hi

It is possible(not safe) to disable this option if you want, but why?
You can also send the file outside Excel as a attachment.

 

[Guest]

Basically, I want to disable it for the user opening the
file to force them to use a command button to send the
workbook.

 

[Ron de Bruin]

Ok

This will disable the Send To menu

Sub test()
Application.CommandBars.FindControl(ID:=30095).Enabled = False
End Sub

This the icon on the Standard Toolbar

Sub test2()
Application.CommandBars("Standard").FindControl(ID:=3738).Enabled = False
End Sub

More info here
http://www.rondebruin.com/menuid.htm

 

[Guest]

works like a charm but I had to add a before close event
to re-enable the buttons after I closed the workbook in
question.

thanks a bunch!

 

[Ron de Bruin]

I had to add a before close event

You can also use this events in the Thisworkbook module

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub



The user can use the buttons then in the other workbooks that are open.