Ctrl-click stopped working

[carolynciesla]

Hi everyone:

A minor but infuriating issue: my ctrl-click functionality seems to
have disappeared when a row is highlighted. Clicking on the number to
highlight the row, then ctrl-click no longer brings up the "right
click" menu. Specs: Excel v. 11.2 (Excel for Mac 2004); OS X 10.4.8.

Any solutions would be greatly appreciated.

Thanks,

Carolyn

 

[JE McGimpsey]

A minor but infuriating issue: my ctrl-click functionality seems to
have disappeared when a row is highlighted. Clicking on the number to
highlight the row, then ctrl-click no longer brings up the "right
click" menu. Specs: Excel v. 11.2 (Excel for Mac 2004); OS X 10.4.8.

Since it's apparently only one toolbar (which is how XL generates
contextual menus), try this:

Type OPT-F11 to enter the Visual Basic Editor (VBE). Type CMD-g to open
the Immediate Window. In the Immediate Window, type or paste

Application.CommandBars(45).Reset

followed by Return. Type OPT-F11 to return to XL.



Alternatively, with XL closed, delete the

~:Libraryreferences:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory). Note that this will remove any
customizations you've done to other toolbars.