suspending code execution
 

Hello all,

Have an unusual problem.

I've written a module (as Worksheet_SelectionChange) that builds out a hierarchical organization chart. So, the first level of executives are displayed in column A. The user selects a cell (it highlights) and all of the selected executive's subordinates at the next level populate column B (the data is from a large table on a different sheet). The user has the option of continually selecting deeper into the organization until the lowest level is reached.

The goal is to enable certain reports to be generated at any level.

My problem is that if someone inadvertently deletes a name from column A, there's no easy way to rebuild the first tier of names as every click relaunches the build out macro. I've tried repopulating column A every time the macro is launched, but I get into a recursive loop.

Is there any way to suspend the build out macro if I have to repopulate the starting data?

Art

suspending code execution
 

Hi,

can you show us the code ?

isabelle

Le 2016-11-04 Ã* 14:30, c1802362 a écrit :
Hello all,

Have an unusual problem.

I've written a module (as Worksheet_SelectionChange) that builds out a
hierarchical organization chart. So, the first level of executives are
displayed in column A. The user selects a cell (it highlights) and all of the
selected executive's subordinates at the next level populate column B (the
data is from a large table on a different sheet). The user has the option of
continually selecting deeper into the organization until the lowest level is
reached.

The goal is to enable certain reports to be generated at any level.

My problem is that if someone inadvertently deletes a name from column A,
there's no easy way to rebuild the first tier of names as every click
relaunches the build out macro. I've tried repopulating column A every time
the macro is launched, but I get into a recursive loop.

Is there any way to suspend the build out macro if I have to repopulate the
starting data?

Art

vợ Bui kêu chá»— trÆ°a xong Bùi Gấu Huyen Nguyen :v. Gam cả nay phá Máº*p gặp Ä‘áº*p Ä�ang chị vá»� Má»›i em Tâm đấy. Gá»�i Nguyen Thu chồng Jessica gá»�i Ä‘i ăn
Bao Hiem Nhan Tho Daiichi

Tôi lÃ* tôi đồng ý vá»›i ý kiến của chủ thá»›t

suspending code execution
 

Unfortunately, no I can't (proprietary issues within our company) - however, I did figure out the issue. I've recoded the sheet to run a subroutine that rebuilds the initial list if someone inadvertently deletes a name


On Friday, November 4, 2016 at 2:30:07 PM UTC-4, c1802362 wrote:
Hello all,

Have an unusual problem.

I've written a module (as Worksheet_SelectionChange) that builds out a hierarchical organization chart. So, the first level of executives are displayed in column A. The user selects a cell (it highlights) and all of the selected executive's subordinates at the next level populate column B (the data is from a large table on a different sheet). The user has the option of continually selecting deeper into the organization until the lowest level is reached.

The goal is to enable certain reports to be generated at any level.

My problem is that if someone inadvertently deletes a name from column A, there's no easy way to rebuild the first tier of names as every click relaunches the build out macro. I've tried repopulating column A every time the macro is launched, but I get into a recursive loop.

Is there any way to suspend the build out macro if I have to repopulate the starting data?

Art

omachi
mì omachi
mì gói omachi

omachi

mì omachi
mì gói omachi