I'm running a piece of code via the Worksheet_Change Event and I have it working with a call to an unprotect sub at the beginning of the event and a matching call to a protect sub at the end of the...

I am using Open XML SDK for creating excel files. I want to protect them with a password. Do you know anyway to protect excel file with a password by using Open XML SDK? I know "com" object way...

I have the following code to protect the sheets of a workbook in Excel 2007 Private Sub password_protectallsheets() For Each ws In Worksheets ws.protect Password = "edc1" Next End Sub but when I...

I have an Excel 2010 workbook. One worksheet imports data from an external data connection (SQL query). I have also added additional columns to the worksheet to perform calculations on the data and...

I have a number of sheets which I need to protect except for certain ranges. Is it possible to do this with a script, as I have several sheets, and many ranges within the sheet which I need to be...

When I call Thisworkbook.Protect in VBA the protection of the workbook actually toggles from the current workbook's protection status instead of just protecting the workbook. Thisworkbook.Unprotec...

I'm trying to permanently lock/protect certain cells on 14 different sheets (1 hidden from the workers for formula stuff). I have them all locked and no one can edit if I add them to it as an edito...