View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default right click menu

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




"tina" wrote in message ...
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.