Consulting

Results 1 to 2 of 2

Thread: "FIXED OBJECT WILL MOVE" ERROR IN EXCEL

  1. #1

    "FIXED OBJECT WILL MOVE" ERROR IN EXCEL

    Hi there

    I am trying to use the auto filter in my spreadsheet & each time I click the combo box to filter information, I get a dialg box displaying the above message. I've tried clicking the OK button & that does not work and the only way I can get rid of the error message is by terminating Excel in the task manager, else the message continues looping and does not allow me to exit or do anything in the program.

    I had a logo on the spreadsheet which I have deleted and still get the same error. I have comments which I have checked to ensure they do not overlap the print areas. Other than that, there are no other objects.

    I have no idea what to do.

    Any suggestions/ideas would be great.

    Thanks in advance
    Cosmicsyzygy.

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    From Dave Peterson:
    Tools|options|Edit tab|
    Uncheck the "cut, copy, and sort objects with cells"

    http://www.officefrustration.com/showthread.php?t=55264
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

Posting Permissions

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