Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mystery of the moving control toolbox combo box?
Oh, what I go through just to get a yellow background.
So I have these control toolbox combo boxes on some sheets. Only one per sheet. (These are the same ones discussed in my post earlier today.) The sheets are fully protected. But when I print, the boxes shift a ways over to the left. Always to the same spot. If I comment out the line ActiveSheet.PrintOut and run the code, they do not shift. On the printout they are in their correct location. A mystery to me. Anyone have an idea what is going on? I know if I give up on the yellow background and go back to one on the Forms toolbar all will be fine. But do I have to? Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mystery of the moving control toolbox combo box?
xl2002???
http://support.microsoft.com/default...b;EN-US;838910 Controls move to the left of the worksheet in Microsoft Excel 2002 But Jim Rech recently posted this: This article is now obsolete. Since the 10/12/2004 security patch there is no need to get a hotfix (although this article does not directly mention this fix, it's in there). http://support.microsoft.com/default...b;en-us;832332 But Myrna Larson posted that it didn't work for her in all her workbooks. Don Wiss wrote: Oh, what I go through just to get a yellow background. So I have these control toolbox combo boxes on some sheets. Only one per sheet. (These are the same ones discussed in my post earlier today.) The sheets are fully protected. But when I print, the boxes shift a ways over to the left. Always to the same spot. If I comment out the line ActiveSheet.PrintOut and run the code, they do not shift. On the printout they are in their correct location. A mystery to me. Anyone have an idea what is going on? I know if I give up on the yellow background and go back to one on the Forms toolbar all will be fine. But do I have to? Don <donwiss at panix.com. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mystery of the moving control toolbox combo box?
On Sun, 26 Dec 2004, Dave Peterson wrote:
Don Wiss wrote: ... I have these control toolbox combo boxes on some sheets. ... when I print, the boxes shift a ways over to the left. xl2002??? Yes. http://support.microsoft.com/default...b;EN-US;838910 Controls move to the left of the worksheet in Microsoft Excel 2002 It says to switch to Move and size with cells. I can do that. I need move with cells, but which ever size is set to shouldn't matter. That fixed the problem. But Jim Rech recently posted this: This article is now obsolete. Since the 10/12/2004 security patch there is no need to get a hotfix (although this article does not directly mention this fix, it's in there). http://support.microsoft.com/default...b;en-us;832332 But Myrna Larson posted that it didn't work for her in all her workbooks. I have automatic Windows updates, but I gather that is only for the OS. I will get this now... Nope. It says my Office products need no updates. I do now remember that I updated Office in the past month or so. So like Myrna it didn't work for me. And then this application is for work, and I don't know whether they have this update. But the switch to Move and size with cells is fine. Thanks. I spent a good while trying to pin down the cause of this mystery. Don <donwiss at panix.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is code to activate a combo box in control toolbox | Excel Discussion (Misc queries) | |||
combo box from control toolbox | Excel Discussion (Misc queries) | |||
control toolbox combo box | Excel Discussion (Misc queries) | |||
No change event on control toolbox combo box when selection is the same? | Excel Programming | |||
Control Toolbox | Excel Programming |