Aretradeser
Board Regular
- Joined
- Jan 16, 2013
- Messages
- 173
- Office Version
- 2013
- Platform
- Windows
On a protected sheet I have a control box. This box control is linked to cell C1. When running this I always get the following error: The cell you are trying to modify is protected and therefore read-only. To modify a protected cell or graph, remove the check-in using the Check Out Sheet command (Review tab, Change group). password may be prompted.
The control box runs the following code:
The control box runs the following code:
VBA Code:
Sub Unprotect()
ActiveSheet.Unprotect Password:=“123"
End Sub