+ Reply to Thread
Results 1 to 1 of 1

Using Worksheet_Activate, should I?

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    58

    Using Worksheet_Activate, should I?

    I am trying to make sure a colomn is sorted after a worksheet tab is clicked.

    Worksheet Period1 has names in column K, this column has to be sortable by the user.(This sorts column K by Alpha and then sorts the entire worksheet accordingly.)
    Worksheet Individual has combo boxes that receive these names.

    I need column K on Period1 sorted Alpha (A - Z) everytime Individual is accessed, this way the names match up to the combo box reference numbers. I am calling macro's using the reference numbers.

    Please Login or Register  to view this content.
    I have tried doing this with Worksheet_Activate, but it goes into a loop, so I tried using Application.EnableEvents = False then Application.EnableEvents = True and I am not sure it has ever been set back to True. How can I confirm this?

    Can anyone help me with this?
    Ken
    Last edited by melnikok; 07-24-2007 at 12:59 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1