+ Reply to Thread
Results 1 to 2 of 2

sort macro that works after leaving worksheet

  1. #1
    Registered User
    Join Date
    05-05-2006
    Posts
    4

    sort macro that works after leaving worksheet

    i have a page that has information that i want to sort. the sorting of the information is no problem however i want it to happen automatically when i leave that worksheet to go to a summary page. any ideas?

  2. #2
    Forum Contributor
    Join Date
    03-23-2006
    Location
    Vancouver
    Posts
    114

    Private Sub Worksheet_Deactivate()

    Copy the code of your sorting macro into the Worksheet_Deactivate
    function attached to the sheet that contains the data to be sorted.

    Tools > Macro > Visual Basic Editor

    In the top left window of the interface double click the sheet that has your data.

    From the lefthand dropdown menu select Worksheet
    From the righthand dropdown menu select Deactivate

+ 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