PDA

View Full Version : customize menus



talytech
04-25-2008, 06:51 AM
I'm trying to customize the menu bar for my spreadsheet. I don't want the end user to be allowed to use the send email function, or the save as function. How do I do that in Excel?

xld
04-25-2008, 07:14 AM
With Application.CommandBars("Worksheet Menu Bar")
.Controls("File").Controls("Send To").Enabled=False
.Controls("File").Controls("Save As").Enabled=False
End With