View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Trap insert row or column in Excel in VBA

I believe you are out of luck, Grzegorz. No such event. You must play around
with combinations of selectionchange, change and calculate events to trap
what you look for.

Or just protect the worksheet. No columns can be added or deleted from then
on without your very own column_insert macro.

HTH. Best wishes Harald


"Grzesiek" skrev i melding
...
Hello,

Could you have any idea how to do it ?. I was looked anywhere and not
founded any information about that.
I know, i may use the workbook onchange or calculate event, but i must
necessarily get it just at this event moment.
Please, help me !!!

Thx in advance
Grzegorz