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.

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.