May 07 2019 05:31 AM
Hi
I have a customer that received an protected Excel file from supplier. This file has protections and for example, it denies right-click actions in the file.
But, after this file is closed, these right-click restrictions are preserved in Excel, no matter what file you work with.
I know that I can use Application.CommandBars("Cell").Reset to reset cell right-click to almost normal and also use Application.CommandBars("Cell").enabled=true to cell.
I can also use Application.CommandBars("Ply").Enabled = True to reset sheet tab right-click but I would like to know how can I reset all modifications?
How can I see what modifications has been applied?
What other controls does Application.CommandBars has besides "Cell" and "Ply"?
Is there a way to reset all controls at once?