Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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??
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating workbook with an alpha sort sheet and a numeric sort shee cjlatta Excel Discussion (Misc queries) 2 January 28th 09 12:00 AM
For Each Sheet in Range - Sort Descending NPell Excel Worksheet Functions 7 September 2nd 08 01:31 PM
Sort sheet based on particuilar sort order Also Excel Worksheet Functions 4 January 3rd 08 09:31 AM
formula to sort a range so that it matches the exact rows of a column that is outside that range? steveo Excel Discussion (Misc queries) 1 June 18th 06 02:05 AM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE Excel Discussion (Misc queries) 1 June 24th 05 06:31 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"