Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Right click on rows and columns does not give menu

When I right click on the row numbers and column letters, I do not get the
menu pop up. I had the same issue with not being able to right click on
cells and tabs - but got those fixed by resetting code in VBE. Does anyone
know code to fix the rows and column menu?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Right click on rows and columns does not give menu

Try this.

Sub asdfgh()
Application.CommandBars("column").Reset
Application.CommandBars("row").Reset
End Sub


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 06:46:04 -0700, RSolti
wrote:

When I right click on the row numbers and column letters, I do not get the
menu pop up. I had the same issue with not being able to right click on
cells and tabs - but got those fixed by resetting code in VBE. Does anyone
know code to fix the rows and column menu?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Right click on rows and columns does not give menu

This enables all commandbars/menus:

Sub EnableAllCBs()
Dim CB As CommandBar
For Each CB In CommandBars
CB.Enabled = True
Next
End Sub


--
Jim
"RSolti" wrote in message
...
| When I right click on the row numbers and column letters, I do not get the
| menu pop up. I had the same issue with not being able to right click on
| cells and tabs - but got those fixed by resetting code in VBE. Does
anyone
| know code to fix the rows and column menu?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One-click hide or unhide rows & columns Togowa Excel Worksheet Functions 3 August 11th 12 06:45 PM
Alt Shortcut from right-click menu JB2010 Excel Discussion (Misc queries) 1 July 26th 07 05:08 PM
cannot RIGHT click on rows or columns in excel [email protected] Excel Discussion (Misc queries) 0 October 16th 06 05:46 PM
Can I add a Macro to right-click Menu? Ed Excel Discussion (Misc queries) 8 October 11th 06 02:43 PM
The right click on my mouse does not give me the option to paste Mouse Trouble Excel Discussion (Misc queries) 3 November 23rd 05 05:36 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"