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-08-2012, 10:43 AM

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

Interesting,
Looks like you had to to unlock all the cells first, and then lock the cells you want protected before you protect the sheet.

Reply With Quote