Results 1 to 4 of 4
  1. #1
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hello All,
    When right clicking on a 'column name' the shortcut menu does always show the 'insert' option grayed out.
    When using the normal menu 'insert' the option 'column' is available and works.
    I have tried to reset the shortcut menu in VBA with Application.Commandbars("Column").FindControl(ID:= 297, Recursive:=True).Enabled = True, but this is also not working.

    Who as an idea?

    Thanks in advance
    Patrick Schouten
    Greetings,

    Patrick Schouten
    (The Netherlands)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I haven't seen Excel 2009 yet

    Try Pieterse's Systematic Approach to behavioral Problems in XL.

  3. #3
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783180' date='06-Jul-2009 09:54']I haven't seen Excel 2009 yet

    Try Pieterse's Systematic Approach to behavioral Problems in XL.[/quote]

    Thanks I changed it in 2003
    I will have a look and see if the XLB file could be the problem

    Patrick
    Greetings,

    Patrick Schouten
    (The Netherlands)

  4. #4
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783180' date='06-Jul-2009 09:54']Try Pieterse's Systematic Approach to behavioral Problems in XL.[/quote]

    Yep... Deleting the XLB file corrected my problem.
    So now I have can change Excel to the way I like it again.

    Again, Thanks Hans

    Patrick
    Greetings,

    Patrick Schouten
    (The Netherlands)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •