View Single Post
  #8   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Wayman Bell Wayman Bell is offline
external usenet poster
 
Posts: 1
Default Help - Controls Shift after print preview?

I had been having that problem for 8-9 months. I asked my IT department
what's going on and they blamed me for fiddling with all that fancy stuff
that they thought I had no business messing with. Well all their computers
still want hold the controls in one place but mine does. I downloaded all
the updates, patches, fixes, etc. from Microsoft that I could get but the
problem persisted. Then I tried the work around. That solved my problems but
I have to apply it to each control individually unless I copy one that I had
already 'fixed'. IT has no clue.


"Koye Li" wrote in message
...
Hi,

I have an excel sheet with some standard controls such as buttons and
combo
boxes on it using Excel 2002 SP3. The problem is that after I do a print
preview and closed the print preview window. There are page break dotted
lines displayed on the sheets and all the controls on on the second page
get
shifted to the first page. I've check the lock property on the
controls(buttons, combo boxes etc) to True and that doesn't seem to work.

The strange thing is that on the problem does not exists on my windows XP
system but only happening on my Windows 2000 machine.

Any help would be much appreciated.