right click menu

[tina]

how can i add the options for print, print preview and save as to the right
click menu in excel 2007? were these opitons in the default right click menu
in excel 2003? thanks.

 

[Ron de Bruin]

No they are not in the menu in 2003

print, print preview and save as

You can use

Ctrl-p
Ctrl -F2
F12

To do this also

But if you want to add it you can do this

Sub AddToCellDropDown()
Dim CellDropDown As CommandBar

RemoveFromCellDropDown

Set CellDropDown = Application.CommandBars("Cell")
With CellDropDown
.Controls.Add Type:=msoControlButton, ID:=4
.Controls.Add Type:=msoControlButton, ID:=109
.Controls.Add Type:=msoControlButton, ID:=748
End With
End Sub

Sub RemoveFromCellDropDown()
Dim CellDropDown As CommandBar

Set CellDropDown = Application.CommandBars("Cell")
On Error Resume Next
With CellDropDown
.FindControl(ID:=4).Delete
.FindControl(ID:=109).Delete
.FindControl(ID:=748).Delete
End With
On Error GoTo 0
End Sub



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm