Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I reactive the Hide option on the Format menu?? | Excel Discussion (Misc queries) | |||
read-only option not appearing on file menu | Excel Discussion (Misc queries) | |||
read-only option not appearing on file menu | Excel Discussion (Misc queries) | |||
Restoring the File option on the top Menu bar of Excel. | Excel Discussion (Misc queries) | |||
"Delete sheet" not an available option on File menu. | Excel Worksheet Functions |