Posts by Tweety_19

    I have a spreadsheet which pulls data from other spreadsheets. Every time I open this, I get the "This workbook contains one or more links that cannot be updated error."

    Updating skips past this and all works fine. Choosing edit links shows me that all links have an "OK" status, that the updates are automatic, and I have the startup prompt set to "Don't display the alert and update links".

    So why does this keep popping up, and how can I get this to stop?

    I have a code that protects all worksheets within the open workbook, and it works very well. I've not included a worksheet that I don't want to protect. The worksheet is called "LogDetails". Is it possible to insert some code into the following to exclude protecting this specific tab?

    Sub Protect()
    ' Protect Macro
    ' Protects all worksheets. Protects without a password.
    For i = 1 To Sheets.Count
    Next i
    End Sub