Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 controls move after printing sheet
I have a worksheet with an embedded SpinButton, Label, CommandButton
and CheckBox. If I choose to Print Preview or if I print, the SpinButton and Label controls will shift to the left about 150 points. The Button and CheckBox stay put. More info: These are controls from the "Controls" toolbar and not the "Forms" toolbar. I have checked all the properties for the controls and cannot find any differences that would be causing this behavior. They all have .PrintObject = False and are set to 'move but don't size with cells.' I have a Before_Print event code, but it does not manipulate the worksheet where these controls are. This behavior did not occur in Excel 97, but now occurs in Excel 2002. Any suggestions? Jake |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 controls move after printing sheet
A possibility:
http://support.microsoft.com/default...Product=xl2002 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards, Tom Ogilvy "Jakeman" wrote in message oups.com... I have a worksheet with an embedded SpinButton, Label, CommandButton and CheckBox. If I choose to Print Preview or if I print, the SpinButton and Label controls will shift to the left about 150 points. The Button and CheckBox stay put. More info: These are controls from the "Controls" toolbar and not the "Forms" toolbar. I have checked all the properties for the controls and cannot find any differences that would be causing this behavior. They all have .PrintObject = False and are set to 'move but don't size with cells.' I have a Before_Print event code, but it does not manipulate the worksheet where these controls are. This behavior did not occur in Excel 97, but now occurs in Excel 2002. Any suggestions? Jake |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 controls move after printing sheet
Ha!
Thanks Tom! I get so hooked into coming straight here for answers that I overlooked the obvious. Jake Tom Ogilvy wrote: A possibility: http://support.microsoft.com/default...Product=xl2002 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards, Tom Ogilvy "Jakeman" wrote in message oups.com... I have a worksheet with an embedded SpinButton, Label, CommandButton and CheckBox. If I choose to Print Preview or if I print, the SpinButton and Label controls will shift to the left about 150 points. The Button and CheckBox stay put. More info: These are controls from the "Controls" toolbar and not the "Forms" toolbar. I have checked all the properties for the controls and cannot find any differences that would be causing this behavior. They all have .PrintObject = False and are set to 'move but don't size with cells.' I have a Before_Print event code, but it does not manipulate the worksheet where these controls are. This behavior did not occur in Excel 97, but now occurs in Excel 2002. Any suggestions? Jake |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 controls move after printing sheet
Rather than trying to get a hotfix from MS you can get the October 12, 2004
Security Update that includes it. http://support.microsoft.com/?id=873366 -- Jim Rech Excel MVP "Jakeman" wrote in message oups.com... Ha! Thanks Tom! I get so hooked into coming straight here for answers that I overlooked the obvious. Jake Tom Ogilvy wrote: A possibility: http://support.microsoft.com/default...Product=xl2002 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards, Tom Ogilvy "Jakeman" wrote in message oups.com... I have a worksheet with an embedded SpinButton, Label, CommandButton and CheckBox. If I choose to Print Preview or if I print, the SpinButton and Label controls will shift to the left about 150 points. The Button and CheckBox stay put. More info: These are controls from the "Controls" toolbar and not the "Forms" toolbar. I have checked all the properties for the controls and cannot find any differences that would be causing this behavior. They all have .PrintObject = False and are set to 'move but don't size with cells.' I have a Before_Print event code, but it does not manipulate the worksheet where these controls are. This behavior did not occur in Excel 97, but now occurs in Excel 2002. Any suggestions? Jake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls move upon printing in Excel 2003 | Excel Discussion (Misc queries) | |||
Controls move upon printing in E | Excel Discussion (Misc queries) | |||
CheckBox and ComboBox controls move on previewing or printing | Excel Programming | |||
Move a row to the centre of my sheet Excel 2002 | Excel Programming | |||
A wacky problem - controls move on the screen after printing | Excel Programming |