Excel Right-Click modifications

Brass Contributor

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?

1 Reply

Anybody? Anything??