Excel Right-Click modifications
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?