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

Groups > microsoft.public.excel.programming > #109569

Re: suspending code execution

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web