Question: can vba edit locked cells?
Answer: 6 Answers. If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells. The weakness of this method is that if the code is interrupted and error handling does not capture it, the worksheet could be left in an unprotected state.