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
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