Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Corruption? (03)

    I have an Excel file that no longer executes various pieces of code to protect worksheets. I have stepped through the code and I have no issues along the way.

    One thing that I did try is to create a new section of code to protect/unprotect the sheets and this new code works.

    Any ideas as to why the failure?

    Thanks,
    John

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Corruption? (03)

    Your question is kind of like my saying to you, "My car won't start, can you tell me why?" <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

    It will be almost impossibe to answer your question without seeing the workbook. Can you remove all sensitive data and upload it?
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Corruption? (03)

    I found the issue. There was a #Ref in a range. Tthat particular cell should have been a value.

    John

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Corruption? (03)

    That would have been WAY down on my list of guesses based on your statement of the problem. Glad you found it.
    Legare Coleman

Posting Permissions

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