Halting the Worksheet_Change event

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim McLeod (anonymous_at_discussions.microsoft.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 05:11:03 -0700

Dear Group,

I am inserting the contents of a worksheet from a database but every time I change the contents of a cell the Worksheet_Change event is fired. However, I do need to use the Worksheet_Change within the application so I can’t just delete the handler.

Is there any way I can stop this event from firing until the sheet has been created?

Regards,

James.

Relevant Pages

  • RE: I need help writing a macro to replace cell contents. (new to
    ... done any sort of database work and as one of my co-workers ... Begin Loop ... Cell in Column B ... For Worksheet B, C, D, E, F ...
    (microsoft.public.excel.programming)
  • Re: How to capture Max cell value (High Water Mark)
    ... That happens when you right click and view code then click worksheet on the ... dropdown menu before inserting the pasted text. ... High Water Mark cell if it is greater than what already exists. ...
    (microsoft.public.excel)
  • Re: dynamic combobox
    ... I would add data validation to the cell so that users can only select values from the list as it appears on the form. ... Dim ws As Worksheet ... 'find first empty row in database ...
    (microsoft.public.excel.programming)
  • Re: Prevent Formulas from updating
    ... I have a list of network login names on a hidden worksheet with the ... access database and populate the cells. ... the database value then don't alter the contents of the cell and leave the ...
    (microsoft.public.excel.programming)
  • Re: userform - active sheet
    ... or just set a cell object to that cell ... > Sheet2: Database with range of cells ... > is the code to hide the worksheet when the file is opened?) ...
    (microsoft.public.excel.programming)