Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Objects moving on Sheet (2002)

    I developed a workbook for a client. its purpose is to print timesheets for specific time periods. There are three "drop down boxes". The first one allows the user to select a name, and two others select "start date" and "end date". Then one command button that prints time sheets within the date range for the name selected. It works fine EXCEPT for two workstations. On two workstations each time they click on the PRINT command button all the objects move to the left side of the spread sheet. Then they close the spread sheet and reopen it and the objects are in their original location... they press Print... they all move left. ???
    I've checked everything I can think of, including the properties for the objects, they are "locked" and even the Options for Excel, they are the same as every other workstation in the office.
    <img src=/S/cranky.gif border=0 alt=cranky width=18 height=25>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Objects moving on Sheet (2002)

    This is a bug in Excel 2002 SP-3, see Controls move to the left of the worksheet in Microsoft Excel 2002. The workaround is to set the controls to move and size with cells.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Objects moving on Sheet (2002)

    VERY helpful....thank you! This was driving us crazy! <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •