elgatnegre
New Member
- Joined
- Nov 19, 2014
- Messages
- 7
Hi guys,
my question is really so simple. How to run a macro every time a table object (List Object) changes its size?
I'm working on a layout template and I need to tell excel to adjust some of my layout's elements each and every time the fourth list object of the sheet (ActiveSheet.ListObjects(4)) changes the size of its range (in other words, every time the user makes the table grow in its number of rows or columns, even if the user does that by using the excel's build-in form that can be used for managing the table's records).
I figure some kind of event approach should be used, but after some days of research I still haven't got the right path.
Any help?
greetings from Barcelona
my question is really so simple. How to run a macro every time a table object (List Object) changes its size?
I'm working on a layout template and I need to tell excel to adjust some of my layout's elements each and every time the fourth list object of the sheet (ActiveSheet.ListObjects(4)) changes the size of its range (in other words, every time the user makes the table grow in its number of rows or columns, even if the user does that by using the excel's build-in form that can be used for managing the table's records).
I figure some kind of event approach should be used, but after some days of research I still haven't got the right path.
Any help?
greetings from Barcelona