Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109534 > unrolled thread

suspending code execution

Back to article view | Back to microsoft.public.excel.programming

Contents

  suspending code execution c1802362 <utay1@cox.net> - 2016-11-04 11:30 -0700
    Re: suspending code execution isabelle <i@v.invalid> - 2016-11-07 23:01 -0500
    Re: suspending code execution vuvanxuongcntt <vuvanxuongcntt@gmail.com> - 2016-11-09 08:12 +0000
    Re: suspending code execution c1802362 <utay1@cox.net> - 2016-11-11 12:48 -0800
    Re: suspending code execution trmn584 <trmn584@gmail.com> - 2016-11-12 11:24 +0000
    Re: suspending code execution trmn584 <trmn584@gmail.com> - 2016-11-12 11:58 +0000

#109534 — 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

[toc] | [next] | [standalone]

#109560

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
>

[toc] | [prev] | [next] | [standalone]

#109566

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




-- 
vuvanxuongcntt

[toc] | [prev] | [next] | [standalone]

#109569

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

[toc] | [prev] | [next] | [standalone]

#109573

'omachi' (http://tinyurl.com/zkxq4bc)
'mì omachi' (http://tinyurl.com/zkxq4bc)
'mì gói omachi' (http://tinyurl.com/zkxq4bc)




-- 
trmn584

[toc] | [prev] | [next] | [standalone]

#109574

'omachi
' (http://tinyurl.com/zoasfza)
'mì omachi' (http://tinyurl.com/zoasfza)
'mì gói omachi' (http://tinyurl.com/zoasfza)




-- 
trmn584

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web