Is it possible to provide the Sample file which is protected? Just so that we can come to a conclusion faster and provide you with Solutions options.
Yes sure
Management_Diamond_Value.xls (74.5 KB)
Here is the sample file.
Please check the unhide sheet option it will be disabled because it is password protected.
Enter password as :- “abcdef” to unprotect the sheet in
review>protect workbook.
and than unhide tab will be enabled.
Do Check if the below workflow works for your case :
Excel_ProtectWorkbook.zip (66.0 KB)
It requires Microsoft.Office.Interop.Excel Package to be installed from Manage Packages.
Examine the Invoke Code activity, Between the Unhiding and Hiding of the Sheets you could perform your required operation.
You could also split this Invoke Code into two, where the first Invoke Code would UnProtect the Workbook and Unhide all sheets so that you can work on it later using Studio activities.
The Second Invoke Code should hide all the sheets and Protect the Workbook, to bring it back to the initial Form.
Let us know if you are able to understand and split the Invoke Code as needed.
Hi @supermanPunch
Thank you so much for helping me out. It worked perfectly fine. 
Thanks,
Kunal
1 Like
Hi @supermanPunch
Can we add an if activity in the invoke code so that I can use the same workflow as protected and unprotected using If condition.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
manasrlenka25