• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extending outline/group when adding row to Excel table

hjaeger

New Member
All,


I'm a VBA newbie, so I'm looking for guidance to solve a particular problem


As far as I know, there are two ways of adding a row to an Excel table:


1. Highlight a row, right click and select Insert from the context menu

2. Press the Tab key when you're in the last (bottom right) cell of the table


When using the Outline/Group function in combination with Excel tables, I am facing a problem: if I add rows using option 1 above everything is fine, the outline/group is expanded to include the new row - if I add rows using option 2 above, the outline/group is not expanded


Therefore, I would like to find out if it is possible to catch the adding of a rows to an Excel table by pressing the Tab key in the last cell of the table - and then through VBA expand the outline/group to include the new row. Alternatively, is it possible to prevent the user from adding a new line by pressing the Tab key through VBA? (I don't believe this is possible to configure without VBA)


Thanks in advance for you input and ideas


Cheers,


Henrik
 
Back
Top