How will edit the protected .xlsm sheet without password


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”)
End Sub

Let me know the result

Suresh J

1 Like

Hi @Nambi

Check this


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.