![]() |
when I right click on a excel worksheet, I do not get the dropdow.
Has anyone had a problem with displaying the dropdown menu containing
Edit|Paste|etc in the worksheet. I have a user who has this problem. I have remove and re-installed Office to no avail. |
Maybe you have some code disabling it.
Try entering Application.Commandbars("Cell").Visible = True on the VBIDE immediate window (Ctrl-G). If that brings it back, search for some similar code in your start-up workbooks. -- HTH Bob Phillips "Nbhatt" wrote in message ... Has anyone had a problem with displaying the dropdown menu containing Edit|Paste|etc in the worksheet. I have a user who has this problem. I have remove and re-installed Office to no avail. |
Hi Bob, I think you have a small typo Application.Commandbars("Cell").Visible = True should be: Application.Commandbars("Cell").Enabled -- Regards, Norman "Bob Phillips" wrote in message ... Maybe you have some code disabling it. Try entering Application.Commandbars("Cell").Visible = True on the VBIDE immediate window (Ctrl-G). If that brings it back, search for some similar code in your start-up workbooks. -- HTH Bob Phillips "Nbhatt" wrote in message ... Has anyone had a problem with displaying the dropdown menu containing Edit|Paste|etc in the worksheet. I have a user who has this problem. I have remove and re-installed Office to no avail. |
And just to prove that typos are contagious:
Application.Commandbars("Cell").Enabled S/be Application.Commandbars("Cell").Enabled =True --- Regards, Norman "Norman Jones" wrote in message ... Hi Bob, I think you have a small typo Application.Commandbars("Cell").Visible = True should be: Application.Commandbars("Cell").Enabled -- Regards, Norman "Bob Phillips" wrote in message ... Maybe you have some code disabling it. Try entering Application.Commandbars("Cell").Visible = True on the VBIDE immediate window (Ctrl-G). If that brings it back, search for some similar code in your start-up workbooks. -- HTH Bob Phillips "Nbhatt" wrote in message ... Has anyone had a problem with displaying the dropdown menu containing Edit|Paste|etc in the worksheet. I have a user who has this problem. I have remove and re-installed Office to no avail. |
Thanks Norman, too many options with the differing CBs ;-(
Bob "Norman Jones" wrote in message ... And just to prove that typos are contagious: Application.Commandbars("Cell").Enabled S/be Application.Commandbars("Cell").Enabled =True --- Regards, Norman "Norman Jones" wrote in message ... Hi Bob, I think you have a small typo Application.Commandbars("Cell").Visible = True should be: Application.Commandbars("Cell").Enabled -- Regards, Norman "Bob Phillips" wrote in message ... Maybe you have some code disabling it. Try entering Application.Commandbars("Cell").Visible = True on the VBIDE immediate window (Ctrl-G). If that brings it back, search for some similar code in your start-up workbooks. -- HTH Bob Phillips "Nbhatt" wrote in message ... Has anyone had a problem with displaying the dropdown menu containing Edit|Paste|etc in the worksheet. I have a user who has this problem. I have remove and re-installed Office to no avail. |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com