+ Reply to Thread
Results 1 to 6 of 6

Error on Hide Column

  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Error on Hide Column

    I'm trying to manually hide columns M:IU. When I do, I get an error "Cannot Shift Objects Off The Sheet".

    That doesn't make sense to me.
    I'm concluding that my file is corrupted. Is there any other reason for this error?
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Error on Hide Column

    Hi foxguy,

    Are you using any "Comments" on the sheet?
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Error on Hide Column

    No comments on the sheet.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Error on Hide Column

    Hello foxguy,

    Can you post a copy of the workbook?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Error on Hide Column

    Sorry, can't post the workbook. I tried making a mock copy, but I couldn't reproduce the error in it.

    I'm convinced that the file is corrupted, so I'm in the process of cleaning it up. Code Cleaner crashes trying to clean it up, which gives me more evidence that the file is corrupted.

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Error on Hide Column

    Hello foxguy,

    If it is crashing Code Cleaner then I would have to suspect that it is corrupted. Do have a working copy of the file that you can test on another machine to verify the workbook is corrupt?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1