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

I think I disabled/made hidden Save AS instrad of Save;for Save use "&Save"
insead of "Save&AS..." within the code.



"AA2e72E" wrote:

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"