Right click in cell menu options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi AlisonJS

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

Application.CommandBars("Cell").Reset
 
How do I do that?

Press ALT+F11 to open the Visual Basic Editor. There, press
CTRL+G to open the Immediate window. In the Immediate window,
enter

Application.CommandBars("Cell").Reset

and press Enter.

Then, chose the VBA Editor from the File menu to return to Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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
 
Thanks to both you - it worked!!!!

:)


Chip Pearson said:
Press ALT+F11 to open the Visual Basic Editor. There, press
CTRL+G to open the Immediate window. In the Immediate window,
enter

Application.CommandBars("Cell").Reset

and press Enter.

Then, chose the VBA Editor from the File menu to return to Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Back
Top