Alt -F11 (open the VBA editor)
Ctrl-g (open immediate window)
Paste this code line
Application.CommandBars("Cell").Reset

And press Enter

Alt-q to go back to Excel



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi AlisonJS

You can reset the cell menu
run this code like one time

Application.CommandBars("Cell").Reset



--
Regards Ron de Bruin
http://www.rondebruin.nl


"AlisonJS" wrote in message ...
Hi there, I have two users and when they right click on a cell in Excel, they
get only half the menu options the rest of my users have. I can't work out
why. It happens in every Excel file they open or create.

They have all the copy/cut/paste options, and Insert/Clear Contents/Delete,
but they are missing

Insert comments
Format Cells
Pick from drop down list
Add watch
Hyperlink
Lookup

Any ideas?
create list