• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

auto sort button

Hi all--

I am trying to do what I thought was easy (wrong :) ). All I want to do is create a button to sort data based on three diffent levels. I am in Excel 2010 but have it in compatability mood to accomodate the rest of the company. I have tried using the insert Button in Form Controls and the Command Button in the Active X Controls. Please give me the proper procedure and sequence, because what I am doing keeps closing Excel and then losing unsaved data. Thanks in advance.

Lawrence
 
It'll help us be more specific if we can see the code you have now.

Until then, Quick and Dirty:

1) Record a macro of you sorting the data the way you want it

2) Edit macro, remove any excess "fluff", adjust range call-outs, if needed

3) Create button from Form Controls, assign newly written macro
 
Back
Top