Results 1 to 12 of 12

Thread: [RESOLVED] Workbook_Open event won't run

Hybrid View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Posts
    382

    Re: Workbook_Open event won't run

    OK, I think I've found the culprit, or at least one of them. When I clear the conditional formatting from the first sheet, everything works (including the XSformatcleaner). When I add it back, it fails. Here's my CF code:

    Code:
    =NOT(IsFormula(B6))
    The rule applies to a named range 'editable_values'. When a user overwrites the formula in a cell within this range with a value, the cells fill color is changed.

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Posts
    382

    Re: Workbook_Open event won't run

    Was never able to find out why the CF kept the wb open event from running. I switched the CF formatting which changed the cells interior color to a worksheet change event that changed the cells interior color. Everything working now. Thanks for all your tries to help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width