Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
How do I do that?
Sorry am not hot on code or difficult stuff! Thanks. "Ron de Bruin" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
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 "AlisonJS" wrote in message ... How do I do that? Sorry am not hot on code or difficult stuff! Thanks. "Ron de Bruin" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click in cell menu options
Thanks to both you - it worked!!!!
:) "Chip Pearson" wrote: 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 "AlisonJS" wrote in message ... How do I do that? Sorry am not hot on code or difficult stuff! Thanks. "Ron de Bruin" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
right click menu missing in cell | Excel Discussion (Misc queries) | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions |