How will edit the protected .xlsm sheet without password

@Nambi

You can create a macro file which will open the the input and remove the data validation,
Sub test()
Dim wb As Workbook
Dim sht As Worksheet
Set wb = Workbooks.Open(“*\Desktop\New Microsoft Excel Worksheet.xlsx”)
Set sht = wb.Worksheets(“Sheet4”)
sht.Cells.Validation.Delete
End Sub

Let me know the result

Thanks,
Suresh J

1 Like

Hi @Nambi

Check this

Thanks
Ashwin.S

It works…Thanks Jiii…

Glad to help @Nambi

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.