Microsoft Office Forums - View Single Post - [Solved] Excel VBA: Worksheet_Change Cells.Protect

Thread: [Solved] Excel VBA: Worksheet_Change Cells.Protect

View Single Post

Old

04-01-2012, 04:35 PM

davesexcel davesexcel is offline

davesexcel is offline

davesexcel uses Windows XP

Windows XP davesexcel uses Office 2007

davesexcel uses Office 2007

Office 2007

Novice

Join Date: Mar 2006

Posts: 7

davesexcel is on a distinguished road

Default

You would have to unlock all the cells first, and then lock the cells you want protected before you protect the sheet.

Reply With Quote