View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
harish harish is offline
external usenet poster
 
Posts: 14
Default Hide Print option from File Menu

I am trying to disable and hide the "Print" option from "File Menu".Also I
want to disable "CTRL + P" and Print icon from standard tool bar.

I have written the code as follow but it's not working.It's coming with an
error that" Invalid procedure call or argument."

Sub Macro1()

Sheets("Sheet1").Select
Application.CommandBars.Item("File").Controls.Item ("Print").Enabled = False
Application.CommandBars.Item("File").Controls.Item ("Print").Visible = False

End Sub


Thanks in advance.

Harish