Thread: disable the Tool menu in toolbar
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
  
Posts: 400
Default disable the Tool menu in toolbar
Yes!

Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Enabled =
False ' Disable option
Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Visible =
False ' Hide option

!Type "Save &AS..." as shown!

"L Scholes" wrote:

Is there a way to do this with File "Save", but leave "Save As"


Reply With QuoteReply With Quote