I am trying to duplicate the sort feature used in this tutorial: http://www.contextures.com/xlSort02.html
The description of the first part of the code suggests that the code creates the invisible rectangles, but I couldn't get it to do this. (I had the create the rectangles manually, ahead of time.) You can demonstrate this using the sample Excel sheet provided (SortClick.zip). If you delete any of the hidden rectangles, save, close and then open the file, the code will not recreate the rectangle and the affected columns will not sort. To get around this, I tried to copy and paste a rectangle from the sample sheet to my own document. (And repasted it for the rest of my columns.) When I do this, it also copies the Macro assigned to that particular rectangle (SortClick.xls!SortTable). Things will work if I manually rename the macro assigned to each rectangle (using the name of my .xls file), but I was hoping to avoid that on the assumption the code can do it dynamically. Am I missing something? Thank you. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
