Hello,
I know this thread is old but thought I'd try anyways.
I am running Windows 7 on my MacBookPro via BootCamp and I have MS Office
2007. I am having "right-click" (2 finger click on my tracking pad)
problems in Excel. When I 2 finger click a cell in Excel, the right-click
menu comes up for a split second then disappears right away. I have tried
resetting with the instructions above with no luck. Any ideas???
Thanks
Ryan
I can no longer get short-cut menus by right clicking on cells or charts
in
Excel 2003. (right clicking does work in other office applications such
as
powerpoint, so I have ruled out a hardware problem) I do not have a
symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any
ideas
for me?
On Saturday, April 07, 2007 2:25 PM Gord Dibben wrote:
John
If no menu appears with a right-click you shoud try re-setting the
r-click.
Hit ALT + F11 to go to the VBEditor.
Then View>Immediate Window.
Copy/paste this line into the window and hit <enter>
Application.CommandBars("Cell").Reset
OR copy/paste this sub to a module and run it.
Sub reset()
Application.CommandBars("Cell").Reset
End Sub
Gord Dibben MS Excel MVP
On Saturday, April 07, 2007 7:18 PM Joh wrote:
Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.
Any other ideas?
"Gord Dibben" wrote:
Application.CommandBars("Cell").enabled = true
Either directly in the immediate window -- or in the procedure.
John wrote:
On Saturday, April 07, 2007 7:50 PM Joh wrote:
Thank you Dave Peterson. That corrected the problem. You made my
Saturday!!
Thanks again,
"Dave Peterson" wrote:
On Sunday, April 08, 2007 1:04 PM Gord Dibben wrote:
Thanks for jumpling in Dave.
Gord
wrote:
On Sunday, April 08, 2007 1:38 PM Dave Peterson wrote:
You're welcome, Gord.
(I just hope that "jumpling" is a good thing <vbg>.)
Gord Dibben wrote:
On Sunday, April 08, 2007 2:04 PM Gord Dibben wrote:
jumpling has never caused me any harm but like anything else,
should be used
only in moderation.
wrote:
On Tuesday, April 10, 2007 12:28 PM Joh wrote:
After using excel again, I realized that the previous macro did
turn on the
menus for cells but did not turn back on the short cut menus for
rows,
columns and charts. With a little digging I came up with the
following macro
that appears to have enabled all the right-click shortcut menus.
Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub
Thanks Gord and Dave for setting me in the right direction.
"Gord Dibben" wrote:
On Tuesday, April 10, 2007 7:25 PM Gord Dibben wrote:
Thanks for the feedback John.
Good job of digging.
Gord
On Wednesday, April 18, 2007 9:04 AM Mayur Shetty wrote:
Go to Task Manager and search for Verclsid and end task.
Then go to C:\Windows and search for the same file and rename
it (Verclsidold).
Re-open Excel and it should work.
If that does not work perform the below steps :-
*Excel11.xlb [D:\Documents and Settings\username\Application
Data\Microsoft\Excel], remove the file and save it in a
different location
{Eg:-desktop}.
* Reopen excel and excel11.xlb gets created.[Delete the
previous excel11.xlb once you confirm from user its all working
fine]
*unregister and register excel
[Unregister - Start- run - excel /unregsvr, Register -
excel /regsvr]
On Tuesday, March 24, 2009 1:52 AM Rosy Armitage wrote:
Just wanted to say a thank you to Gord Dibben for fixing an
excel problem I had with excel cut and paste option not
working. His solution
Hit ALT + 11 for VBEditor
copy/paste this sub to a module and run it.
Sub reset()
Application.CommandBars("Cell").Reset
End Sub
A solution posted for a right-click shortcut menu issue also
worked for my copy/paste issue.
Awesome!
Rosy
On Tuesday, March 24, 2009 5:16 AM Rosy Armitage wrote:
Just wanted to say a thank you to Gord Dibben for fixing an
excel problem I had with excel cut and paste option not
working. His solution
Hit ALT + 11 for VBEditor
copy/paste this sub to a module and run it.
Sub reset()
Application.CommandBars("Cell").Reset
End Sub
A solution posted for a right-click shortcut menu issue also
worked for my copy/paste issue.
Awesome!
Rosy
On Wednesday, June 23, 2010 9:58 AM Kurt Fritz wrote:
This happens because the Excel Options key becomes
corrupted.
To fix, close Excel and open regedit. Go to
HKCU\Software\Microsoft\12.0\Excel and rename the Options
key to Options.old. Open Excel and a new Options key will be
created with default settings, with right-click
functionality restored.
(12.0 is for Office 2007; if using 2010, go to 14.0 instead)
On Friday, July 09, 2010 10:38 AM conan b wrote:
Thanks.
This explanation and resolution (regedit OPTION key
renaming) fixed the problem.
No one here had any idea as to what could have caused this
problem or had ever seen it happen.
I had struggled with key strokes and icon installations on
toolbars as work arounds for the past week; however, years
of habitual use of the shortcut (rightclick and away) was
hard to stop doing. I realized I am addicted to the
SHORTCUT MENU via rightclicking.
I am happy to have the SHORTCUT MENU available again.
Thank you.
On Wednesday, July 21, 2010 7:05 PM Cindy Hoff wrote:
We are having same issue with some of the row and column
edits not available but are instead grayed out. We can't
find the "options key" to rename per the description
below. Is there something else it might be called? We are
using Excel 2007 verstion 12.0.653535002 SP2MSO.
Also the macro for enabling the command bar did not work
we were only able to get the cell edit function to work.
Any ideas on what we may be doing wrong?
Submitted via EggHeadCafe - Software Developer Portal of
Choice
SharePoint Workflow Custom Input Forms
http://www.eggheadcafe.com/tutorial...a/sharepoint-workflow-custom-input-forms.aspx
