Installing Office XP SP3 introduced problems with controls

  • Thread starter Thread starter RP
  • Start date Start date
R

RP

I have several Excel worksheets that have controls placed on them. (command
buttons and option buttons to be exact)
These sheets worked fine in Excel 2000 and in Excel 2002 SP2.
Now, after loading SP3, when you print a page or even print preview it, the
controls on the sheet will move around on the page and will not be where
they were originally placed.
They are all set with the 'Print Object' de-selected.

Has anyone else heard of this problem?

Misc Info:

Windows XP - SP1
Office XP - SP3

Printing to a
Windows 2000 Sp4 Print Server
 
Has anyone else heard of this problem?

Looks like a definite issue. The Print Object setting doesn't matter I
find. Forms toolbar controls are not affected just Control Toolbox
controls. MS will be informed shortly if they don't know about it already.
Thanks for the report.

--
Jim Rech
Excel MVP

| I have several Excel worksheets that have controls placed on them.
(command
| buttons and option buttons to be exact)
| These sheets worked fine in Excel 2000 and in Excel 2002 SP2.
| Now, after loading SP3, when you print a page or even print preview it,
the
| controls on the sheet will move around on the page and will not be where
| they were originally placed.
| They are all set with the 'Print Object' de-selected.
|
| Has anyone else heard of this problem?
|
| Misc Info:
|
| Windows XP - SP1
| Office XP - SP3
|
| Printing to a
| Windows 2000 Sp4 Print Server
|
|
 
To all who are affected by this:

As a temporary solution, we are using the following method to patch the
problem in our Excel workbooks on a file by file basis.
Use this method at your own risk. ( I created this code very quickly, so it
is not real pretty, but it does what I need.)

The problem introduced in SP3 is that if a control's "Object positioning"
property is set to "move but don't size with cells", when you print or print
preview, the controls will lose their positioning on the sheet. The
property must be changed to "move and size with cells" on each control on
the form.
This code, when ran from within the workbook you are correcting, will change
this property for each control in the workbook.
We don't work with charts or any other objects accept for those in the
standard Control Toolbox, so I am not sure what affect this will have on
anything else .
I would recommend that you TEST THIS THOROUGHLY before implementing it on
production files.

Instructions:
I created a new workbook and deleted all sheets except Sheet1.
I created a command button on that sheet and pasted the code into it.
I then saved this file on the server. We now open this file and copy Sheet1
into the workbook that we are trying to fix.
We then click the command button and it runs the fix on the workbook.

Private Sub CommandButton1_Click()
x = ActiveWorkbook.Worksheets.Count
For I = 1 To x
y = Sheets(I).Shapes.Count
For z = 1 To y
Sheets(I).Shapes(z).Placement = xlMoveAndSize
Next
Next
MsgBox "Fix has been applied."
End Sub


This is just a quick and dirty fix to get us by. If Microsoft doesn't come
up with a real fix soon, I may improve this code to make it more automated
and to follow standard programming guidelines. If I do, I will post my code
for that.

Hope this helps.
 
Back
Top