column insert not possible (XL2003NL)

Topic

New Reply

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

Reply | Quote

Replies

I haven’t seen Excel 2009 yet

Try Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

Reply | Quote

I haven’t seen Excel 2009 yet

Try Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

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

Patrick

Reply | Quote

Try Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

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

Reply | Quote