View Full Version : Unlocking all Excel (2007) cells by default

K. Georgiadis
01-04-2014, 11:25 AM
When I start Excel, by default all cells are Locked. For certain projects, the cells that I want to keep locked are relatively few and I would save time if the default setting were Unlocked. Is there a way to do this for an entire workbook, through VBA or otherwise?


01-04-2014, 12:21 PM
Hi there,

I believe you could just toss in a few lines of 'junk/run once and delete" code.

Option Explicit

Sub example()
Dim wks As Worksheet

For Each wks In ThisWorkbook.Worksheets
wks.Cells.Locked = False

End Sub

Hope that helps,


01-04-2014, 09:40 PM
1. You could change the Normal Style to unlocked. Most times people have the Normal Style applied

2. You could format a new 'default' template and put it in your XLstart folder. Only problem I've experienced with that you have to use Control-N and not File, New -- not sure why