Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default 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

  #3   Report Post  
Junior Member
 
Posts: 10
Default

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
  #4   Report Post  
Banned
 
Posts: 2
Default

Tôi lÃ* tôi đồng ý vá»›i ý kiến của chủ thá»›t
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Execution Has Been Interruptred? michael.beckinsale Excel Programming 1 October 5th 06 10:00 PM
Temporarily Suspending Worksheet_Change() until other code is run. andym Excel Programming 4 February 5th 06 03:40 PM
Suspending MAcros Kaval Excel Programming 1 September 27th 04 01:49 AM
suspending-interacting-resuming Ward[_2_] Excel Programming 1 July 8th 04 01:22 PM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"