disabling send as attachment

G

Guest

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

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.
 
G

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.
 
R

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
 
G

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!
 
R

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.
 
Top