View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cam[_3_] Cam[_3_] is offline
external usenet poster
 
Posts: 1
Default 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??