Change the locked option by defualt

Hi all,

By default the excel protection is locked when I open new file.

How can I amend such that by default the "locked" box is not ticked?

Thank you.

I know this option, however I will be performing some automated tasks through VBA on a lot of files. And changing this by default will save a lot of time.

Hi,

The following Macro should get you started. However, if you are not going to 'Protect' any Sheets, it is not needed.

Sub SetAllSheetsToUnlocked()

  Dim ws As Worksheet
  
  'ThisWorkbook is the File that contains this code
  For Each ws In ThisWorkbook.Worksheets
  
    ws.Cells.Locked = False
  
  Next ws

End Sub

Lewis