Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub NotifyUserCellProtected() If ActiveSheet.ProtectContents = True And ActiveCell.Locked = True Then MsgBox "That cell is protected and cannot be changed!" End If On Error GoTo errNumber NormalExit: Exit Sub errNumber: MsgBox Err.Number Resume NormalExit End Sub
|i'm trying to create pivot table using source data using macro script which i recorded and given below. when i run it i'm getting debug error. could anyone help to fix this issue||10||27|
|Excel format formula for currency||15||22|
|Msbbox Notice (4 days)||27||58|
|Return Column Number based on a specific value||25||24|