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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com