Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Objects on sheet move after printing??? (Excel 2002)

    I'm sorry, I can't reproduce the problem in Excel 2002 (SP-2). Could you perhaps attach a very simple demo workbook?

  2. #2
    New Lounger
    Join Date
    Aug 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Objects on sheet move after printing??? (Excel 2002)

    Hi All,

    I have several buttons and labels placed on a sheet that shift to the left after print previewing or printing the sheet. All the objects on the sheet have been locked and have the option 'Do not move or size with cells' checked, but they still all shift to the left. This does not occur if the objects are from the Forms Toolbox rather than the Controls Tool Box. You can try this for yourself - Place an object from each toolbox and then print preview. The object from the Forms Toolbox will not move but the Control Toolbox object will.

    Perhaps there is some property that I have not set that will fix the objects in place.
    Any suggestions please??????

    Thanks Glenn

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

    Re: Objects on sheet move after printing??? (Excel 2002)

    It seems to be a bug in SP-3, that's why I don't see it in your attachment. See MSKB article Controls move to the left of the worksheet in Microsoft Excel 2002.

Posting Permissions

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