![]() |
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?? |
All times are GMT +1. The time now is 01:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com