I have the following VBA marco running in Excel 2003, it blocks the Save, Save as, Save Workspace, Send To 
menus but I now need to do the same but for Excel 2010 ?

> 
> Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save As...").Enabled = False  
> 
>   
> 
> 
> Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save").Enabled = False  
> 
>   
> 
> 
> 
> Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save Workspace...").Enabled = False  
> 
>   
> 
> 
> 
> Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Send To").Enabled = False  
> 
>   
> 
> 
> 
> Application.CommandBars("Worksheet Menu Bar").Controls("Format").Controls("Sheet").Enabled = False  
> 
>   
> 
> 

There is a 'new menu' in Excel 2010 called "Save and send" (under the File ribbon) that I would like to also disable... How do you do this ? I’m searching for the equivalent to a line like this one:

`'Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save & Send").Enabled = False`

Thank you for your help.