Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet.range.sort with ordercustom
The problem <was, i think that in my "Workbook_Open" I hid the
activemenubar, formatting and standard commandBars, and enabled my own custom commandBar, and this <seemed to prevent quite a few different sheet.range.sort's from using an orderCustom number. I say seemed because when I brought back the activemenubar, the orderCustom sorts worked again. And I say was a problem because rather than force me to bring back a bar I was trying to hide, I simply added Application.AddCustomList ListArray:=Array ("d", "4", "e", "5.5", "n") once right before the first sorting code. This seems to awaken something up. It doesn't duplicate it and I get no errors, so I assume it recognizes it. I don't have to change the actual orderCustom numnber (7 btw) and it now sorts in the correct order, (as strange an order as it is). Any thoughts on this? The one extra line (out of about 100) is no big deal, but am I missing something else, or did I just stumble on a quirky problem with a quirky cure? Anyone else find that hinding (.enabled or .visible = false) commandBars causes orderCustom's or other things to not work right? And speaking of not working... are there other things that might not work right once you start hiding things?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
For Each Sheet in Range - Sort Descending | Excel Worksheet Functions | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Discussion (Misc queries) |