Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box Moving
I have been seeing some really starnge behavior with ListBoxs (Control
Toolbox) that are put on worksheets. I had a previous question posted last Thursday about Listbox resizing that has not yet received a response. Here is something else that is happening: with a listbox on a worksheet, I go into print preview mode. When preview is closed, the listbox has moved its position. This happens every time. I am currently dealing with this in the worksheet activate event using code to move it back into position. This is far from ideal since the user must deactivate and then reactivate the sheet in order for it to work. Anyone know why the listbox position may be changing and how to stop it? If not, any suggestions on how to better deal with this behavior using code in events to reposition it? Thanks for your help. Using Excel 2002. Keith Young |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box Moving
http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002 http://groups.google.co.uk/groups?lr...apeXSP AM.com but there was a discussion on this: DAVE PETERSON: There's a link on this URL: http://support.microsoft.com/default.aspx?kbid=838910 How to obtain the hotfix This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix Package May 6, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004 That points to this KB article: http://support.microsoft.com/kb/829348/ Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004 That describe how to contact MS to get the link. It's not just a simple download. Jim Rech says it is fixed in a security update so the hotfix isn't needed: Jim Rech: I think it is, Dave, because it was included in the 10/12/2004 Security Update. MSKB 873366 describes how to get it. As I recall the fix isn't mentioned in the doc, it is there; I read it somewhere and proved to my satisfaction that it worked. I'd be interested to see if you can confirm this. see the discussion: http://groups.google.co.uk/groups?lr...apeXSP AM.com -- Regards, Tom Ogilvy "Keith Young" wrote in message ... I have been seeing some really starnge behavior with ListBoxs (Control Toolbox) that are put on worksheets. I had a previous question posted last Thursday about Listbox resizing that has not yet received a response. Here is something else that is happening: with a listbox on a worksheet, I go into print preview mode. When preview is closed, the listbox has moved its position. This happens every time. I am currently dealing with this in the worksheet activate event using code to move it back into position. This is far from ideal since the user must deactivate and then reactivate the sheet in order for it to work. Anyone know why the listbox position may be changing and how to stop it? If not, any suggestions on how to better deal with this behavior using code in events to reposition it? Thanks for your help. Using Excel 2002. Keith Young |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box Moving
thanks alot Tom
"Tom Ogilvy" wrote in message ... http://support.microsoft.com/default...b;EN-US;838910 Controls move to the left of the worksheet in Microsoft Excel 2002 http://groups.google.co.uk/groups?lr...apeXSP AM.com but there was a discussion on this: DAVE PETERSON: There's a link on this URL: http://support.microsoft.com/default.aspx?kbid=838910 How to obtain the hotfix This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix Package May 6, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004 That points to this KB article: http://support.microsoft.com/kb/829348/ Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004 That describe how to contact MS to get the link. It's not just a simple download. Jim Rech says it is fixed in a security update so the hotfix isn't needed: Jim Rech: I think it is, Dave, because it was included in the 10/12/2004 Security Update. MSKB 873366 describes how to get it. As I recall the fix isn't mentioned in the doc, it is there; I read it somewhere and proved to my satisfaction that it worked. I'd be interested to see if you can confirm this. see the discussion: http://groups.google.co.uk/groups?lr...apeXSP AM.com -- Regards, Tom Ogilvy "Keith Young" wrote in message ... I have been seeing some really starnge behavior with ListBoxs (Control Toolbox) that are put on worksheets. I had a previous question posted last Thursday about Listbox resizing that has not yet received a response. Here is something else that is happening: with a listbox on a worksheet, I go into print preview mode. When preview is closed, the listbox has moved its position. This happens every time. I am currently dealing with this in the worksheet activate event using code to move it back into position. This is far from ideal since the user must deactivate and then reactivate the sheet in order for it to work. Anyone know why the listbox position may be changing and how to stop it? If not, any suggestions on how to better deal with this behavior using code in events to reposition it? Thanks for your help. Using Excel 2002. Keith Young |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving contacts from one list to another | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
Moving a range to end of list | Excel Programming | |||
Moving a range to end of list | Excel Programming | |||
Moving a range to end of list | Excel Programming |